[프로그래머스] 동명 동물 수 찾기

728x90

SELECT name, count(*) as count
from animal_ins
where name is not null
group by name
having count > 1
order by name