Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
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 ;