0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Korean language

SELECT SUM(CASE WHEN cnt is null THEN 0 ELSE 1 END) as Nula, SUM(CASE WHEN cnt BETWEEN 1 AND 10 THEN 1 ELSE 0 END) as JednaAzDeset, SUM(CASE WHEN cnt > 10 THEN 1 ELSE 0 END) as DesetPlus from (select u.Id, count(*) cnt from Users u inner join Posts on u.Id=Posts.OwnerUserId group by u.Id) p

fork query

edited mar 20

created mar 20 anonymous