최대 1 분 소요

문제 링크

정답

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