서브쿼리 알아보기

문자열 다루기

날짜 다루기

JOIN 알아보기

SQL 조건문

REGEXP 가 뭔데

HAVING 이 뭐였더라

CEIL, FLOOR, ROUND, TRUNCATE

ANY, ALL

GROUP_CONCAT()

FROM WHERE GROUP HAVING SELECT ORDER

LEAST(1, 2, 3) → 1

https://velog.io/@coddingyun/SQL-함수-정리

# SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
# FROM ANIMAL_INS
# WHERE NAME in ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
# ORDER BY ANIMAL_ID

SELECT 
    RANK() OVER(PARTITION BY ANIMAL_TYPE ORDER BY NAME) as num, 
    ANIMAL_TYPE, NAME, ANIMAL_ID
FROM ANIMAL_INS;

# (SELECT *, ROW_NUMBER() OVER (PARTITION BY OCCUPATION ORDER BY NAME) RN
#       FROM OCCUPATIONS)

프로그래머스 SQL문제풀이

HackerRank SQL 문제풀이