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(1) AS number_of_posts_per_user
  FROM Users u
  LEFT JOIN Posts p
    ON u.Id = p.OwnerUserId
  GROUP BY u.Id
  )
SELECT COUNT(1)
FROM t1
WHERE t1.number_of_posts_per_user = 0;

fork query

edited jul 3

created jul 3 anonymous