SQL 구문 익히기
select point_user_id, avg(point),
CASE
when avg(point) > (select round(avg(point)) from point_users) then '잘하고 있어요!'
else '열심히 합시다!'
END as 'msg'
from point_users
group by point_user_id
select substring_index(email, '@', -1) as domain, count(*) from users
group by domain
select ed.enrolled_id, count(ed.enrolled_id), total_cnt from enrolleds_detail ed
inner join
(
select enrolled_id, count(enrolled_detail_id) as total_cnt from enrolleds_detail
group by enrolled_id
) a
on ed.enrolled_id = a.enrolled_id
where ed.done=1
group by enrolled_id
