[Programmers][SQL] 동명 동물 수 찾기 (59041번) - MySQL Solution

문제

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

---

Solution

SELECT NAME, COUNT(NAME) FROM ANIMAL_INS GROUP BY NAME HAVING COUNT(NAME) > 1 ORDER BY NAME