SQL 알고리즘 코드카타

SQL 알고리즘 코드카타(입양 시각 구하기(1)) 26.04.09(목)

nom_de_plume 2026. 4. 9. 23:47

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

select
    hour(datetime) as hour,
    count(animal_id) as count
from animal_outs
where hour(datetime) between 9 and 19
group by hour(datetime)
order by hour(datetime)


3. 오류 상황:

4. 시도 방법:

5. 최종 문제 해결 방법: