1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of hardware and software for Raspberry Pi

SELECT TOP 100
  OwnerUserId AS UserId,
  OwnerUserId AS [User Link],
  COUNT(*) AS AllQ
FROM Posts
WHERE
  PostTypeId = 1
  AND
  OwnerUserId > 0
GROUP BY OwnerUserId
HAVING COUNT(AcceptedAnswerId)=0
ORDER BY AllQ DESC, UserId

fork query

edited may 15 19

created may 15 19 peterh (2)