Total Questions, Answers, and Comments of 1000 most recently active users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

SELECT TOP 50
SUM(CASE WHEN Posts.PostTypeId = 1 THEN 1 ELSE 0 END) AS Questions
FROM Users
INNER JOIN Posts ON Posts.OwnerUserId = Users.Id
INNER JOIN Comments ON Comments.UserId = Users.Id
WHERE Posts.OwnerUserId = 7128934
GROUP BY Posts.PostTypeId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results