[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로 접근