Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
Select Count(p.Id) As Posts, pt.Name As Type, u.DisplayName As Name From Posts p Inner Join Users u On p.OwnerUserId = u.Id Inner Join PostTypes pt On pt.Id = p.PostTypeId Where u.DisplayName = 'Mat Mannion' And pt.Name = 'Question' Group By pt.Name, u.DisplayName;