level 2. 동명 동물 수 찾기

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

코딩테스트 연습 - 동명 동물 수 찾기

-- MySQL
SELECT NAME, count(NAME) AS COUNT
    FROM ANIMAL_INS 
    GROUP BY NAME 
        HAVING COUNT>1 
    ORDER BY NAME
    
-- Oracle, MySQL
SELECT NAME, count(NAME) AS COUNT
    FROM ANIMAL_INS 
    GROUP BY NAME 
        HAVING count(NAME)>1 
    ORDER BY NAME