[Programmers SQL 고득점 Kit] GROUP BY [1/4] 고양이와 개는 몇 마리 있을까

문제 link
https://programmers.co.kr/learn/courses/30/lessons/59040

Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/03_GROUP_BY/GROUP_BY-1.sql

SELECT ANIMAL_TYPE, COUNT(ANIMAL_ID) AS count
FROM ANIMAL_INS
GROUP BY ANIMAL_TYPE
ORDER BY ANIMAL_TYPE;