Distribution of Flags by Type

1

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

Options:
Switch sites:
loading Hold tight while we fetch your results