select Count(*), Name as [Vote Type] from votes as v join...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Count(*), Name as [Vote Type]
from votes as v
join votetypes as t on v.votetypeid = t.id
where postid = 1995113
group by votetypeid, name

Enter Parameters

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