[SQL문제풀기] FrontEnd 개발자 찾기

문제

MYSQL

내가 작성한 정답

SELECT DISTINCT D.ID, D.EMAIL, D.FIRST_NAME, D.LAST_NAME
FROM DEVELOPERS D
JOIN SKILLCODES S ON D.SKILL_CODE & S.CODE != 0
WHERE S.CATEGORY = 'Front End'
ORDER BY ID ASC;

ON D.SKILL_CODE & S.CODE != 0 

EXIST이용한 다른 방법

SELECT ID, EMAIL, FIRST_NAME, LAST_NAME
FROM DEVELOPERS D
WHERE EXISTS (
    SELECT 1
    FROM SKILLCODES S
    WHERE S.CATEGORY = 'Front End'
      AND (D.SKILL_CODE & S.CODE) != 0
)
ORDER BY ID ASC;