SELECT NAME, COUNT(NAME) AS COUNT FROM ANIMAL_INS WHERE NAME IS NOT NULL #NULL 제외하는 코드 GROUP BY NAME HAVING COUNT(NAME) > 1 # 동명(2마리 이상)이니까 having > 1 ORDER BY NAME