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;