[프로그래머스 / SQL] 동명 동물 수 찾기

-Code

SELECT
    NAME, COUNT(NAME) AS 'COUNT'
FROM
    ANIMAL_INS
GROUP BY
    NAME
HAVING
    COUNT(NAME) > 1
ORDER BY
    NAME ASC;