Get number of questions for each amount of close votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

/*select votetypeid, count(*)
from votes
group by votetypeid
*/

select c, count(*)
from
(
select u.id, count(*) c
from votes v
left join users u on v.userid = u.id
where votetypeid = 6
group by u.id
) a
group by c;

Enter Parameters

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