[SQL_SUM,MAX,MIN]

📌중복 제거하기

SELECT COUNT(DISTINCT(NAME)) AS count
FROM ANIMAL_INS

📌동물 수 구하기

SELECT COUNT(ANIMAL_ID) AS COUNT FROM ANIMAL_INS

📌최솟값 구하기

SELECT DATETIME FROM ANIMAL_INS  ORDER BY DATETIME LIMIT 1

📌최댓값 구하기

SELECT DATETIME AS '시간' FROM ANIMAL_INS
ORDER BY DATETIME DESC LIMIT 1

📌가장 비싼 상품 구하기

SELECT PRICE AS MAX_PRICE FROM PRODUCT
ORDER BY PRICE DESC LIMIT 1

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

SELECT * FROM FOOD_PRODUCT
ORDER BY PRICE DESC LIMIT 1