코딩연습이 좋아서/SQL이 좋아서
동명 동물 수 찾기
zoaseo
2025. 2. 3. 22:43
SELECT NAME,
COUNT(NAME) AS COUNT
FROM ANIMAL_INS
GROUP BY NAME
HAVING NAME IS NOT NULL
AND COUNT >= 2
ORDER BY NAME;