Q&A about the site for enthusiasts and scholars of mythology and folklore
SELECT Posts.OwnerUserId, SUM(CASE WHEN Posts.PostTypeId = 1 THEN 1 ELSE 0 END) AS Questions, SUM(CASE WHEN Posts.PostTypeId = 2 THEN 1 ELSE 0 END) AS Answers FROM Posts GROUP BY Posts.OwnerUserId