Q&A for professional and enthusiast programmers
select count (Posts.PostTypeId), Posts.OwnerDisplayName as "Name" from Posts where Posts.OwnerDisplayName = 'Mat Mannion' and Posts.PostTypeId = 1 group by Posts.OwnerDisplayName