0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select vt.name as VoteType, count(*) as "VoteCount"
from VoteTypes vt,
     Votes v,
     Posts p
where vt.id = v.VoteTypeId
  and v.PostId = p.id
  and p.PostTypeId = 2
group by vt.name

view current version

edited oct 11 18

created oct 11 18 rolfl