59041.md

프로그래머스 59041

'동명 동물 수 구하기'

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

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