0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

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
;

fork query

edited nov 6

created nov 5 anonymous