ratio of questions to answers

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT Users.Id,
CAST(ABS(SUM(Posts.PostTypeId - 2)) AS FLOAT) AS Asked,
CAST(SUM(Posts.PostTypeId -1) AS FLOAT) AS Answered
FROM Users
LEFT JOIN Posts on Posts.OwnerUserId = Users.Id
GROUP BY Users.Id