DATABASE, MYSQL, SUM/MAX/MIN

1.

최대값 구하기

SELECT DATETIME
FROM ANIMAL_INS
ORDER BY DATETIME DESC
LIMIT 1

2.

최솟값 구하기

SELECT DATETIME
FROM ANIMAL_INS
ORDER BY DATETIME
LIMIT 1

3.

동물 수 구하기

SELECT COUNT(*) COUNT
FROM ANIMAL_INS

4.

중복제거

SELECT  count(distinct name) from ANIMAL_INS