[SQL문제풀기] 동명 동물 수 찾기

문제

MYSQL, ORACLE

SELECT NAME, COUNT(NAME) COUNT
FROM ANIMAL_INS
GROUP BY NAME
HAVING COUNT(NAME) >= 2
ORDER BY NAME ASC