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 u.id, count(*) c
from votes v
left join users u on v.userid = u.id
where votetypeid = 6
group by u.id
*/

/*
select userid, count(*)
from votes
--where votetypeid = 6
group by userid
*/

select votetypeid, count(distinct userid) from votes
group by votetypeid

Enter Parameters

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