
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 [1146] [42S02]: Table 'sparta.table1' doesn't exist
어느부분이 문제인지 찾기가 어렵네요
