[Programmers SQL 고득점 Kit] GROUP BY [2/4] 동명 동물 수 찾기

문제 link
https://programmers.co.kr/learn/courses/30/lessons/59041

Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/03_GROUP_BY/GROUP_BY-2.sql

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