[JOIN/LEVEL4] FrontEnd 개발자 찾기 (MySQL)

MySQL

SELECT    ID
        , EMAIL
        , FIRST_NAME
        , LAST_NAME
FROM DEVELOPERS A, SKILLCODES B
WHERE CATEGORY = 'Front End'
AND (A.SKILL_CODE & B.CODE) > 0
GROUP BY ID, EMAIL, FIRST_NAME, LAST_NAME
ORDER BY ID