[내일배움단] 엑셀보다 쉬운 SQL
2023. 6. 4. 18:41ㆍ카테고리 없음
[3주차] study
select e.enrolled_id,
e.user_id,
count(*) as cnt
from enrolleds e
inner join enrolleds_detail ed on e.enrolled_id = ed.enrolled_id
where ed.done = 1
group by e.enrolled_id, e.user_id
order by cnt desc
반응형