[프로그래머스] FrontEnd 개발자 찾기

문제

제출

SELECT id,email,first_name,last_name
from developers
where skill_code & (select sum(code) from skillcodes where category = 'front end')
order by 1 asc

🚨 error

with front as(
select sum(code) sum_code
from skillcodes
where category = 'front end'
)
    
SELECT id,email,first_name,last_name
from developers
where skill_code & front
order by 1 asc

where skill_code & front
front는 CTE에서 생성된 임시 테이블 같은 존재라서,
👉 FROM front처럼 테이블로 사용해야 한다.