0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT 
    P.OwnerUserId, 
    COALESCE(P.OwnerDisplayName, U.DisplayName) AS DisplayName, 
    COUNT(P.Id) AS Number_of_posts
FROM 
    Posts P
LEFT JOIN 
    Users U ON P.OwnerUserID = U.Id 
GROUP BY 
    P.OwnerUserId, 
    COALESCE(P.OwnerDisplayName, U.DisplayName)
ORDER BY 
    Number_of_posts DESC
OFFSET 0 ROWS FETCH NEXT 15 ROWS ONLY;

view current version

edited oct 13

created oct 13 anonymous