Lv2. 중복 제거하기

▶ 문제

 

▶ 풀이방법

SELECT COUNT(DISTINCT NAME) as "count"
FROM ANIMAL_INS
WHERE NAME is not NULL;

- DISTINCT : 중복제거