0

Please login or register to vote for this query.

(click on this box to dismiss)

Query of users who answer but never asked a question. Sorted by number of answers for a user.

Q&A for amateur radio enthusiasts

--DECLARE @UserId int = ##UserId##

DECLARE @UserId int = 202935


SELECT top 10 u.DisplayName, (SELECT count(*) FROM Posts WHERE OwnerUserId = u.id AND PostTypeId = 2) [Answers],
(SELECT count(*) FROM Posts WHERE OwnerUserId = u.id AND PostTypeId = 1) [Questions]
--SELECT q.OwnerUserID [User Link], Count(*) [Questions]
FROM Users u
--WHERE Answers != 0
WHERE (SELECT count(*) FROM Posts WHERE OwnerUserId = u.id AND PostTypeId = 2) != 0
AND (SELECT count(*) FROM Posts WHERE OwnerUserId = u.id AND PostTypeId = 1) = 0

ORDER BY Answers
--GROUP BY q.OwnerUserID
--HAVING (SELECT count(*) FROM Posts WHERE OwnerUserId = u.id AND PostTypeId = 2) != 0

view current version

edited mar 20 13

created mar 20 13 BG