select count(*) as NumOfPosts from Posts inner join Users...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select count(*) as NumOfPosts
from Posts
inner join Users on Users.Id = Posts.OwnerUserId
inner join PostTypes on Posts.PostTypeId = PostTypes.Id
where Users.DisplayName = 'Mat Mannion'
and PostTypes.Name = 'Question'
and Posts.CreationDate > (select CreationDate from Users where DisplayName = 'Mat Mannion')

Enter Parameters

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