0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for linguists, etymologists, and serious English language enthusiasts

WITH UserPosts AS (
        SELECT OwnerUserId, COUNT(OwnerUserId) AS Post_count
        FROM Posts
        GROUP BY OwnerUserId
        HAVING COUNT(OwnerUserId) >10
)
SELECT 
          COUNT(u.id) AS Počet_uživatelů_10_posty
FROM Users u
INNER JOIN UserPosts up ON u.id = up.OwnerUserId;

fork query

edited may 27

created may 27 anonymous