Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
SELECT u.Id AS [User Link], (SELECT SUM(p2.ViewCount) FROM Posts AS p2 WHERE p2.OwnerUserId = u.Id) AS "Views", SUM(CASE WHEN v.VoteTypeId = 2 AND p.PostTypeId = 1 THEN 1 ELSE 0 END) AS "QUpVotesReceived", SUM(CASE WHEN v.VoteTypeId = 3 AND p.PostTypeId = 1 THEN 1 ELSE 0 END) AS "QDownVotesReceived", SUM(CASE WHEN v.VoteTypeId = 2 AND p.PostTypeId = 2 THEN 1 ELSE 0 END) AS "AUpVotesReceived", SUM(CASE WHEN v.VoteTypeId = 3 AND p.PostTypeId = 2 THEN 1 ELSE 0 END) AS "ADownVotesReceived" FROM Users AS u INNER JOIN Posts AS p ON u.Id = p.OwnerUserId INNER JOIN Votes AS v ON p.Id = v.PostId GROUP BY u.Id