0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for historians and history buffs

WITH t1 AS (
  SELECT u.Id AS user_id, COUNT(p.Id) AS number_of_posts_per_user
  FROM Users u
  LEFT JOIN Posts p
    ON u.Id = p.OwnerUserId
  GROUP BY u.Id
  )
SELECT TOP 5 *
FROM t1
WHERE number_of_posts_per_user > 10;

fork query

edited jul 3

created jul 3 anonymous