동명 동물 수 찾기(Programmers)

답 쿼리입니다.

SELECT NAME
     , COUNT(NAME) COUNT
FROM ANIMAL_INS
WHERE NAME IS NOT NULL
GROUP BY NAME
HAVING COUNT(NAME) >= 2
ORDER BY NAME

NAME NAME NAME ••