0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
       count(*) as TotalVotes,
       SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) AS QuestionVotes
FROM    Votes v JOIN Posts p ON v.PostId=p.Id
WHERE  UserId = 234175;

fork query

created jan 3 11 Michael Mrozek