SELECT users.DisplayName ,users.Location ,prolific_users.*

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  users.DisplayName
       ,users.Location
       ,prolific_users.*
FROM
(
SELECT TOP 100  OwnerUserId
               ,OwnerDisplayName
               ,COUNT(Id) AS num_of_posts
               ,AVG(CAST(Score AS FLOAT)) AS average_score
FROM Posts
WHERE CAST(CreationDate AS DATE) >= '2021-09-01'
    AND CAST(CreationDate AS DATE) < '2021-10-01'
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
) AS prolific_users
LEFT JOIN Users AS users
  ON prolific_users.OwnerUserId = users.Id

Enter Parameters

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