Distribution of Flags by Type

1

Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

-------------------------
-- @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