Q&A for community managers, administrators, and moderators
SELECT TOP 100 Users.Id AS [User Link], --COUNT( Unaccepted.Id ) AS Unaccepted--, --COUNT( Accepted.Id ) AS Accepted * FROM Users LEFT JOIN Posts AS Unaccepted ON Users.Id = Unaccepted.OwnerUserId LEFT JOIN Posts AS Accepted ON Users.Id = Accepted.OwnerUserId WHERE Unaccepted.PostTypeId = 1 --questions AND Unaccepted.AcceptedAnswerId IS NOT NULL AND Accepted.PostTypeId = 1 --questions AND Accepted.AcceptedAnswerId IS NOT NULL AND Users.Id < 10 --GROUP BY --Users.Id