[프로그래머스] SQL 고득점 Kit : 입양 시각 구하기

https://school.programmers.co.kr/learn/courses/30/lessons/59412

프로그래머스

 

 

-- 코드를 입력하세요
SELECT hour(DATETIME) as HOUR, count(DATETIME) as COUNT
from ANIMAL_OUTS
where hour(DATETIME) >= 9 and hour(DATETIME) < 20
group by HOUR
order by HOUR