본문 바로가기
💻 하나씩 차곡차곡/프로그래머스 (SQL)

[SELETE/LEVEL2] 조건에 맞는 개발자 찾기 (MySQL)

by 뚜루리 2024. 10. 31.
728x90
320x100

MySQL

SELECT ID
, EMAIL
, FIRST_NAME
, LAST_NAME
FROM DEVELOPERS
WHERE SKILL_CODE & (SELECT CODE FROM SKILLCODES WHERE NAME = 'Python')
    OR SKILL_CODE & (SELECT CODE FROM SKILLCODES WHERE NAME = 'C#')
ORDER BY ID;
728x90
320x100