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

silver

May 15, 2025

Contents

문제 MYSQL

문제

school.programmers.co.kr

https://school.programmers.co.kr/learn/courses/30/lessons/276013

MYSQL

1. 내가 작성한 정답


select ID,EMAIL,FIRST_NAME,LAST_NAME
from DEVELOPER_INFOS
where 'Python' in (SKILL_1,SKILL_2,SKILL_3)
order by 1;

💡


where 'Python' in (SKILL_1,SKILL_2,SKILL_3)

oracle에서는 사용불가

2. 저번에 작성한 정답


SELECT ID, EMAIL, FIRST_NAME, LAST_NAME
FROM DEVELOPER_INFOS
WHERE (SKILL_1='PYTHON')
        OR (SKILL_2='PYTHON')
        OR (SKILL_3='PYTHON')
ORDER BY ID ASC;