instruction: Whose posts do I comment on?.
response: SELECT UserId AS "user_link", CommentCount, up.postCount, ROUND(CAST(CommentCount AS FLOAT) / up.postCount, 2) AS ratio FROM (SELECT COUNT(c.Id) AS commentCount, p.OwnerUserId AS userid FROM (SELECT Id, PostId FROM Comments WHERE UserId = '##userid##') AS c JOIN Posts AS p ON c.PostId = p.Id GROUP BY p.OwnerUserId) AS c JOIN (SELECT OwnerUserId, COUNT(Id) AS postCount FROM Posts GROUP BY OwnerUserId) AS up ON up.OwnerUserId = c.UserId WHERE CommentCount >= '##minCommentCount##' ORDER BY c.CommentCount DESC