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 d1.Posts_cnt > 10 THEN 1 ELSE 0 END) as More_than_10,
SUM(CASE WHEN d1.Posts_cnt = 0 THEN 0 ELSE 1 END) as Zero_posts,
SUM(CASE WHEN d1.Posts_cnt between 1 and 10 THEN 1 ELSE 0 END) as "Between"
from 
(
select u.Id, count (u.Id) as Posts_cnt
from Users u
left join Posts p
on u.Id = p.OwnerUserId
group by u.Id
) d1;

fork query

edited mar 20

created mar 20 anonymous