💻 하나씩 차곡차곡/프로그래머스 (SQL)
[SELETE/LEVEL2] 조건에 맞는 개발자 찾기 (MySQL)
뚜루리
2024. 10. 31. 00:00
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