Has the most questions, but never accepted anything

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

--WITH Raw AS (
  SELECT
    OwnerUserId AS UserId,
    COUNT(*) AS AllQ
  FROM Posts
  WHERE
    PostTypeId = 1
    AND
    OwnerUserId > 0
  GROUP BY OwnerUserId
  HAVING COUNT(AcceptedAnswerId)=0
/*)
SELECT
  UserId,
  UserId AS [Post Link],
  AllQ
FROM Raw
WHERE AccQ = 0
ORDER BY AllQ DESC, UserId

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results