[프로그래머스/SQL 고득점 Kit] SUM,MIN,MAX ALL SOLVE

가격이 제일 비싼 식품의 정보 출력하기

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

프로그래머스

SELECT PRODUCT_ID, PRODUCT_NAME, PRODUCT_CD, CATEGORY, PRICE
FROM FOOD_PRODUCT
WHERE PRICE = (SELECT MAX(PRICE)
              FROM FOOD_PRODUCT)

 

가장 비싼 상품 구하기

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

프로그래머스

SELECT MAX(PRICE) as MAX_PRICE
FROM PRODUCT

 

최댓값 구하기

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

프로그래머스

SELECT DATETIME as "시간"
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MAX(DATETIME)
                 FROM ANIMAL_INS)

 

최솟값 구하기

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

프로그래머스

SELECT DATETIME as "시간"
FROM ANIMAL_INS
WHERE DATETIME = (SELECT MIN(DATETIME)
                 FROM ANIMAL_INS)

 

동물 수 구하기

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

프로그래머스

SELECT count(*) as count
FROM ANIMAL_INS

 

중복 제거하기

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

프로그래머스

SELECT count(DISTINCT NAME) as count
FROM ANIMAL_INS