instruction: Total count of up- and downvotes in the system from the Users and the Votes table.
response: SELECT 'Users Table' AS Source, SUM(UpVotes) AS Ups, SUM(DownVotes) AS Downs FROM Users UNION SELECT 'Votes Table' AS Source, COUNT(CASE WHEN VoteTypeId = 2 THEN 1 ELSE NULL END) AS Ups, COUNT(CASE WHEN VoteTypeId = 3 THEN 1 ELSE NULL END) AS Downs FROM Votes