Q&A for professional and enthusiast programmers
SELECT VT.Name, COUNT(*) AS Count FROM Votes V INNER JOIN VoteTypes VT ON V.VoteTypeID = VT.ID WHERE V.UserID = 36388 GROUP BY VT.Name