instruction: Number of votes per vote type.
response: SELECT MIN(VoteTypes.Name) AS "Vote Type", Votes.VoteTypeId, COUNT(*) AS N FROM Votes LEFT JOIN VoteTypes ON Votes.VoteTypeId = VoteTypes.Id GROUP BY Votes.VoteTypeId ORDER BY Votes.VoteTypeId