Questions per user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT u.Id user_id, u.DisplayName username, COUNT(p.Id) questions_asked FROM Users u
JOIN Posts p ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 1 --Question (2 for answer)
GROUP BY u.Id, u.DisplayName
ORDER BY questions_asked DESC

Enter Parameters

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