Q&A about the site for gardeners and landscapers
------------------------- -- @author: Moradnejad -- ------------------------- SELECT p.CommentCount, Count(*) as rCount, Count(Distinct p.Id) as pCount, CAST(Count(*)/Count(Distinct p.Id) as Float) as AvgFlag From posts p inner join ReviewTasks r on r.PostId = p.Id where p.PostTypeId = 1 group by CommentCount order by CommentCount ASC