Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism
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;