0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT OwnerUserId, Id
FROM Posts
ORDER BY OwnerUserId DESC;
WITH RankedPosts AS (
    SELECT 
        OwnerUserId AS user_id,
        COUNT(Id) AS post_count,
        ROW_NUMBER() OVER (ORDER BY COUNT(Id) DESC) AS row_num
    FROM 
        Posts
    GROUP BY 
        OwnerUserId
)
SELECT 
    user_id,
    post_count
FROM 
    RankedPosts
WHERE 
    row_num <= 15;

fork query

edited oct 29

created oct 29 anonymous