with vote_results as ( select votetypeid, count(*) as "nu...

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

with vote_results as (
select votetypeid, count(*) as "number of votes"
from posts 
inner join votes
on posts.id = votes.postid
where posts.owneruserid = 625403
group by votetypeid)

select *
from vote_results
inner join
votetypes
on vote_results.votetypeid = votetypes.id

Enter Parameters

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