💯

SQL TEST

SQL 코딩 테스트 관련 문제들을 정리해놓은 곳입니다.

Table

Search

이름

태그

한 번 더 체크

링크

모든 레코드 조회하기

SELECT

https://programmers.co.kr/learn/courses/30/lessons/59034

역순 정렬하기

SELECT

https://programmers.co.kr/learn/courses/30/lessons/59035

아픈 동물 찾기

SELECT

https://programmers.co.kr/learn/courses/30/lessons/59036

여러 기준으로 정렬하기

SELECT

https://programmers.co.kr/learn/courses/30/lessons/59404

상위 n 개 레코드

SELECT

https://programmers.co.kr/learn/courses/30/lessons/59405

최댓값 구하기

Aggregate Function

https://programmers.co.kr/learn/courses/30/lessons/59415

동물 수 구하기

Aggregate Function

https://programmers.co.kr/learn/courses/30/lessons/59406

중복 제거하기

Aggregate Function

https://programmers.co.kr/learn/courses/30/lessons/59408

고양이와 개는 몇 마리 있을까

GROUP BY

https://programmers.co.kr/learn/courses/30/lessons/59040

동명 동물 수 찾기

GROUP BY

https://programmers.co.kr/learn/courses/30/lessons/59041

입양 시각 구하기(1)

GROUP BY

https://programmers.co.kr/learn/courses/30/lessons/59412

입양 시각 구하기(2)

GROUP BY

전역변수

https://programmers.co.kr/learn/courses/30/lessons/59413

이름이 없는 동물의 아이디

NULL

https://programmers.co.kr/learn/courses/30/lessons/59039

이름이 있는 동물의 아이디

NULL

https://programmers.co.kr/learn/courses/30/lessons/59407

NULL 처리하기

NULL

https://programmers.co.kr/learn/courses/30/lessons/59410

없어진 기록 찾기

JOIN

https://programmers.co.kr/learn/courses/30/lessons/59042

있었는데요 없었습니다

JOIN

https://programmers.co.kr/learn/courses/30/lessons/59043

오랜 기간 보호한 동물(1)

JOIN

https://programmers.co.kr/learn/courses/30/lessons/59044

보호소에서 중성화한 동물

JOIN

https://programmers.co.kr/learn/courses/30/lessons/59045

루시와 엘라 찾기

String

https://programmers.co.kr/learn/courses/30/lessons/59046

이름에 el이 들어가는 동물 찾기

String

https://programmers.co.kr/learn/courses/30/lessons/59047

중성화 여부 파악하기

String

CASE

https://programmers.co.kr/learn/courses/30/lessons/59409

오랜 기간 보호한 동물(2)

Date

https://programmers.co.kr/learn/courses/30/lessons/59411

DATETIME에서 DATE로 형 변환

Date

https://programmers.co.kr/learn/courses/30/lessons/59414

헤비 유저가 소유한 장소

서브쿼리

https://programmers.co.kr/learn/courses/30/lessons/77487

우유와 요거트

JOIN

서브쿼리

https://programmers.co.kr/learn/courses/30/lessons/62284

COUNT26

Table

Search

이름

태그

한 번 더 체크

링크

Revising the Select Query I

Select

https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true

Weather Observation Station 3

Select

https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true

Weather Observation Station 4

Select

https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true

Weather Observation Station 5

Select

ORDER BY

https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true

Weather Observation Station 6

String

https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true

Type of Triangles

CASE

https://www.hackerrank.com/challenges/what-type-of-triangle/problem?isFullScreen=true

String

https://www.hackerrank.com/domains/sql?filters[subdomains][]=advanced-select

서브쿼리

전역변수

https://www.hackerrank.com/challenges/occupations/problem?isFullScreen=true

Binary Tree Nodes

서브쿼리

https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true

Select

JOIN

서브쿼리

https://www.hackerrank.com/challenges/the-company/problem?isFullScreen=true

Aggregate Function

String

https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true

GROUP BY

서브쿼리

https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true

Weather Observation Station 20

서브쿼리

Median

SELF_JOIN

https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true

JOIN

IF

https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true

Top Competitors

JOIN

https://www.hackerrank.com/challenges/full-score/problem?isFullScreen=true

Ollivander’s Inventory

서브쿼리

https://www.hackerrank.com/challenges/harry-potter-and-wands/problem?isFullScreen=true

서브쿼리

https://www.hackerrank.com/challenges/challenges/problem?isFullScreen=true

Draw The Triangle 1

Select

String

전역변수

https://www.hackerrank.com/challenges/draw-the-triangle-1/problem?isFullScreen=true

SQL Project Planning

Date

JOIN

https://www.hackerrank.com/challenges/sql-projects/problem?isFullScreen=true

Symmetric Pairs

SELF_JOIN

https://www.hackerrank.com/challenges/symmetric-pairs/problem?isFullScreen=true

Table

Search

이름

태그

한 번 더 체크

링크

Delete Duplicate Emails

DELETE

UPDATE

https://leetcode.com/problems/swap-salary/submissions/

Reformat Department Table

CASE

https://leetcode.com/problems/reformat-department-table/

Second Highest Salary

Aggregate Function

https://leetcode.com/problems/second-highest-salary/submissions/