test

0

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

SELECT TOP 10 OwnerUserId, OwnerDisplayName
FROM
  (SELECT 
          OwnerDisplayName,
          OwnerUserId,
          rank() over( ORDER BY CAST(COUNT(
              CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1 END) AS float) / cast(count(OwnerUserId) AS float)DESC) AS rating
   FROM posts
   GROUP BY OwnerDisplayName,OwnerUserId
   HAVING count(OwnerUserId)>20)TEMP
WHERE rating = 1
GROUP BY OwnerDisplayName,OwnerUserId;

Enter Parameters

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