[Programmers][SQL] 고양이와 개는 몇 마리 있을까 (59040번) - MySQL Solution

문제

• https://programmers.co.kr/learn/courses/30/lessons/59040

---

Solution

SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) AS COUNT from ANIMAL_INS GROUP BY ANIMAL_TYPE ORDER BY ANIMAL_TYPE