
with table1 as (
select ed.enrolled_id, count(*) as total_cnt from enrolleds_detail ed
group by ed.enrolled_id
), table2 as (
select ed.enrolled_id, count(*) as done_cnt from enrolleds_detail ed
where done = 1
group by ed.enrolled_id
)
select a.enrolled_id,
b.done_cnt,
a.total_cnt,
from table1 a
inner join table2 b on a.enrolled_id = b.enrolled_id
위처럼 코드를 작성했는데 자꾸 에러가 뜨네요. 어디가 잘못된건지 도움부탁드립니다!
