SELECT TOP 100 OwnerUserId ,OwnerDisplayName ,COUNT(Id) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Spanish Language

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

SELECT TOP 100  OwnerUserId
               ,OwnerDisplayName
               ,COUNT(Id) AS num_of_posts
               ,AVG(CAST(Score AS FLOAT)) AS average_score
FROM Posts
GROUP BY  OwnerUserId
         ,OwnerDisplayName
HAVING COUNT(Id) >= 3
    AND AVG(CAST(Score AS FLOAT)) >= 1.5
ORDER BY  average_score DESC
         ,num_of_posts DESC

Enter Parameters

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