* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.

선생님이랑 똑같이 해는데 실행이 안됩니다..

왜일까요?

with table1 as (

select enrolled_id, count(*) as done_cnt from enrolleds_detail

where done = 1

group by enrolled_id

), table2 as (

select enrolled_id, count(*) as total_cnt from enrolleds_detail

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

SQL Error [1064] [42000]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8