https://programmers.co.kr/learn/courses/30/lessons/59040?language=mysql
SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) AS count
FROM ANIMAL_INS
GROUP BY ANIMAL_TYPE
ORDER BY 1
SELECT 컬럼 FROM 테이블 GROUP BY 그룹화할 컬럼;
SELECT 컬럼 FROM 테이블 WHERE 조건식 GROUP BY 그룹화할 컬럼;