Distribution of Flags by Type


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- @author: Moradnejad --
select rt.Name, count(*)
from posts as p
inner join [ReviewTasks] as r on r.PostId = p.id
inner join [ReviewTaskTypes] as rt on rt.Id = r.ReviewTaskTypeId
where p.posttypeid = 1 or p.posttypeid = 2
group by rt.Name

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results