Lv2. 동명 동물 수 찾기

▶ 문제

 

▶ 풀이방법

SELECT NAME, COUNT(NAME) as "COUNT"
FROM ANIMAL_INS
WHERE NAME is not NULL
GROUP BY NAME
HAVING COUNT(NAME) >= 2
ORDER BY NAME;

- 일반 테이블 조건 : WHERE

- 집계값 조건 : HAVING