# [SQL] 프로그래머스 문제풀이

- Author: @mildsalmon
- Published: 2021-09-21
- Updated: 2021-10-16
- Source: http://blex.me/@mildsalmon/sql-%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EB%AC%B8%EC%A0%9C%ED%92%80%EC%9D%B4
- Tags: 프로그래머스, 문제, sql, db, 목차

---

# 1. Oracle

### A. Level 1

##### a. SELECT

[[프로그래머스] 동물의 아이디와 이름 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EB%8F%99%EB%AC%BC%EC%9D%98-%EC%95%84%EC%9D%B4%EB%94%94%EC%99%80-%EC%9D%B4%EB%A6%84)

[[프로그래머스] 모든 레코드 조회하기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%EB%AA%A8%EB%93%A0-%EB%A0%88%EC%BD%94%EB%93%9C-%EC%A1%B0%ED%9A%8C%ED%95%98%EA%B8%B0)

[[프로그래머스] 상위 n개 레코드 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%83%81%EC%9C%84-n%EA%B0%9C-%EB%A0%88%EC%BD%94%EB%93%9C)

[[프로그래머스] 아픈 동물 찾기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%95%84%ED%94%88-%EB%8F%99%EB%AC%BC-%EC%B0%BE%EA%B8%B0)

[[프로그래머스] 어린 동물 찾기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%EC%96%B4%EB%A6%B0-%EB%8F%99%EB%AC%BC-%EC%B0%BE%EA%B8%B0)

[[프로그래머스] 여러 기준으로 정렬하기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%97%AC%EB%9F%AC-%EA%B8%B0%EC%A4%80%EC%9C%BC%EB%A1%9C-%EC%A0%95%EB%A0%AC%ED%95%98%EA%B8%B0)

[[프로그래머스] 역순 정렬하기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%97%AD%EC%88%9C-%EC%A0%95%EB%A0%AC%ED%95%98%EA%B8%B0)

### B. Level 2

##### a. GROUP BY

[[프로그래머스] 동명 동물 수 찾기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EB%8F%99%EB%AA%85-%EB%8F%99%EB%AC%BC-%EC%88%98-%EC%B0%BE%EA%B8%B0)

[[프로그래머스] 입양 시각 구하기_1 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%9E%85%EC%96%91-%EC%8B%9C%EA%B0%81-%EA%B5%AC%ED%95%98%EA%B8%B0_1)

##### b. SUM, MAX, MIN

[[프로그래머스] 중복 제거하기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%A4%91%EB%B3%B5-%EC%A0%9C%EA%B1%B0%ED%95%98%EA%B8%B0)

##### c. String, Date

[[프로그래머스] String, Date - 루시와 엘라 찾기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-string-date-%EB%A3%A8%EC%8B%9C%EC%99%80-%EC%97%98%EB%9D%BC-%EC%B0%BE%EA%B8%B0)

[[프로그래머스] String, Date - 이름에 EL이 들어가는 동물 찾기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-string-date-%EC%9D%B4%EB%A6%84%EC%97%90-el%EC%9D%B4-%EB%93%A4%EC%96%B4%EA%B0%80%EB%8A%94-%EB%8F%99%EB%AC%BC-%EC%B0%BE%EA%B8%B0)

[[프로그래머스] String, Date - 중성화 여부 파악하기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-string-date-%EC%A4%91%EC%84%B1%ED%99%94-%EC%97%AC%EB%B6%80-%ED%8C%8C%EC%95%85%ED%95%98%EA%B8%B0)

##### d. IS NULL

[[프로그래머스] IS NULL - NULL 처리하기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-is-null-null-%EC%B2%98%EB%A6%AC%ED%95%98%EA%B8%B0)

### C. Level 3

##### a. String, Date

[[프로그래머스] 연습문제 - 오랜 기간 보호한 동물(2) — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-%EC%97%B0%EC%8A%B5%EB%AC%B8%EC%A0%9C-%EC%98%A4%EB%9E%9C-%EA%B8%B0%EA%B0%84-%EB%B3%B4%ED%98%B8%ED%95%9C-%EB%8F%99%EB%AC%BC2)

##### b. 2021 Dev-Matching

[[프로그래머스] 2021 Dev-Matching - 헤비 유저가 소유한 장소 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-2021-dev-matching-%ED%97%A4%EB%B9%84-%EC%9C%A0%EC%A0%80%EA%B0%80-%EC%86%8C%EC%9C%A0%ED%95%9C-%EC%9E%A5%EC%86%8C)

##### c. JOIN

[[프로그래머스] JOIN - 없어진 기록 찾기 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-join-%EC%97%86%EC%96%B4%EC%A7%84-%EA%B8%B0%EB%A1%9D-%EC%B0%BE%EA%B8%B0)

[[프로그래머스] JOIN - 있었는데요 없었습니다 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-join-%EC%9E%88%EC%97%88%EB%8A%94%EB%8D%B0%EC%9A%94-%EC%97%86%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4)

[[프로그래머스] JOIN - 오랜 기간 보호한 동물(1) — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-join-%EC%98%A4%EB%9E%9C-%EA%B8%B0%EA%B0%84-%EB%B3%B4%ED%98%B8%ED%95%9C-%EB%8F%99%EB%AC%BC1)

### D. Level 4

##### a. JOIN

[[프로그래머스] JOIN - 보호소에서 중성화한 동물 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-join-%EB%B3%B4%ED%98%B8%EC%86%8C%EC%97%90%EC%84%9C-%EC%A4%91%EC%84%B1%ED%99%94%ED%95%9C-%EB%8F%99%EB%AC%BC)

##### b. GROUP BY

[[프로그래머스] GROUP BY - 입양 시각 구하기(2) — mildsalmon (blex.me)](https://blex.me/@mildsalmon/%ED%94%84%EB%A1%9C%EA%B7%B8%EB%9E%98%EB%A8%B8%EC%8A%A4-group-by-%EC%9E%85%EC%96%91-%EC%8B%9C%EA%B0%81-%EA%B5%AC%ED%95%98%EA%B8%B02)

##### c. Summer/Winter Coding(2019)

[Summer/Winter Coding(2019) - 우유와 요거트가 담긴 장바구니 — mildsalmon (blex.me)](https://blex.me/@mildsalmon/summerwinter-coding2019-%EC%9A%B0%EC%9C%A0%EC%99%80-%EC%9A%94%EA%B1%B0%ED%8A%B8%EA%B0%80-%EB%8B%B4%EA%B8%B4-%EC%9E%A5%EB%B0%94%EA%B5%AC%EB%8B%88)

# 2. Mysql