0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT p.OwnerUserId AS "1-10" FROM Posts p
WHERE p.Title is not null
GROUP BY p.OwnerUserId
HAVING COUNT (p.Title) < 11

UNION ALL

SELECT p.OwnerUserId AS "Over 10" FROM Posts p
WHERE p.Title is not null
GROUP BY p.OwnerUserId
HAVING COUNT (p.Title) > 10

fork query

edited apr 24

created apr 24 anonymous