select Posts.OwnerDisplayName as "Name", count (Posts.Pos...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select Posts.OwnerDisplayName as "Name", count (Posts.PostTypeId) as "Total Posts of Type Question"
from Posts
where Posts.OwnerDisplayName = 'Mat Mannion' and Posts.PostTypeId = 1
group by Posts.OwnerDisplayName

Enter Parameters

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