Archive

Programmers. Find number of animals with same name

Archived technical note: Programmers. Find number of animals with same name.

· Record · Code · SQL · Coding Interview · Programmers · Find number of animals with same name · 동명 동물 수 찾기 · 프로그래머스

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


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