[프로그래머스] SELECT : Python 개발자 찾기

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

프로그래머스

 

[풀이과정]

OR 조건, 오름차순 정렬

 

[코드]

SELECT ID, EMAIL, FIRST_NAME, LAST_NAME
FROM DEVELOPER_INFOS
WHERE SKILL_1 = 'Python' || SKILL_2 = 'Python' || SKILL_3 = 'Python'
ORDER BY ID;

SELECT ID, EMAIL, FIRST_NAME, LAST_NAME
FROM DEVELOPER_INFOS
WHERE 'Python' IN (SKILL_1, SKILL_2, SKILL_3)
ORDER BY ID;