Count users that voted on election

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

select
    year(Date) as Year,
    count(distinct UserId) as Users
from 
    Users u
left join 
    Badges b on b.UserId=u.Id
where 
    Name = 'Constituent'
group by
    year(Date)

Enter Parameters

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