SELECT Count(*) number_of_questions FROM PostTypes INNER ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Count(*) number_of_questions FROM PostTypes 
INNER JOIN
(
SELECT  postTypeID FROM users users 
INNER JOIN Posts Post
ON users.id=Post.OwnerUserId
WHERE
displayName='Mat Mannion'
) AS postTypeID_peruser
ON PostTypes.ID = postTypeID_peruser.postTypeID
where  PostTypes.Name='Question'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results