[Level 2] 동명 동물 수 찾기

[문제]

 

 

 

[코드]

SELECT 
    NAME
    , COUNT(*) AS COUNT
FROM ANIMAL_INS
WHERE NAME IS NOT NULL
GROUP BY NAME
HAVING COUNT(*) > 1
ORDER BY NAME ASC;