List the number of questions flagged (/voted) according to each close reason. Will double-count questions if two different reasons are selected.
Q&A for professional and enthusiast programmers
select cr.Name, count(distinct PostId)
from PendingFlags f
join CloseReasonTypes cr on cr.Id=f.CloseReasonTypeId
where FlagTypeId in (14,13)
group by cr.Name
order by count(distinct PostId) desc