Q&A about the site for people looking to bypass life's everyday problems with simple tricks
SELECT ISNULL(vttps.Name,'N/A') as VoteType ,COUNT(1) as NumberOfPosts FROM Posts pst Left Join Votes vts ON vts.PostId = pst.Id Inner Join VoteTypes vttps ON vttps.Id = vts.VoteTypeId GROUP BY ISNULL(vttps.Name,'N/A') ORDER BY NumberOfPosts DESC ;