
with table1 as (
SELECT enrolled_id, count(*) as done_cnt FROM enrolleds_detail ed
WHERE done = 1
group by enrolled_id
), table2 as (
SELECT enrolled_id, count(*) as total_cnt FROM enrolleds_detail ed
group by enrolled_id)
SELECT a.enrolled_id,
a.done_cnt,
b.total_cnt,
round((a.done_cnt/b.total_cnt,2) as ratio
from table1 a
inner JOIN table2 b on a.enrolled_id = b.enrolled_id
코드 똑같이 실행한 거 같은데 실행이 안되는데 제가 틀린 부분이 있나요 ??
