
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 FROM table1 a
inner join table2 b on a.enrolled_id = b.enrolled_id
이렇게 작성했는데 이런 에러가 뜹니다 제가 오타가 난걸까요?
