[SQL] 동명 동물 수 찾기 - GROUP BY ... HAVING ...

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