SQL 알고리즘 코드카타(동명 동물 수 찾기) 26.04.08(수)

1. 문제 링크:https://school.programmers.co.kr/learn/courses/30/lessons/59041
2. 정답 코드: 

select
    name,
    count(name) as count
from animal_ins
group by name
having count(name) >= 2 and name is not null
order by name

3. 오류 상황:

select
    name,
    count(name) as count
from animal_ins
group by name
where count(name) >= 2 and name is not null
order by name

=> 집계화된 함수에 조건 적용

4. 시도 방법:

=> where문 수정

5. 최종 문제 해결 방법:

=> where문을 having문으로 수정