Q&A about the site for members of the workforce navigating the professional setting
SELECT DISTINCT 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