[Programmers] FrontEnd 개발자 찾기
정답
-- SKILLCODES: NAME, CATEGORY, CODE
-- DEVELOPERS: ID, FIRST_NAME, LAST_NAME, EMAIL, SKILL_CODE
WITH FRONTEND_CODE AS (
SELECT SUM(CODE) AS CODE
FROM SKILLCODES
WHERE CATEGORY = 'Front End'
)
SELECT ID, EMAIL, FIRST_NAME, LAST_NAME
FROM DEVELOPERS
WHERE SKILL_CODE & (SELECT CODE FROM FRONTEND_CODE)
ORDER BY ID;
✅ Point
- 포함 여부를 bit로 접근