[프로그래머스] [SQL] 입양 시각 구하기(1)

문제 설명

문제 풀이

SELECT HOUR(DATETIME) AS HOUR, COUNT(DATETIME) as COUNT
FROM ANIMAL_OUTS
GROUP BY HOUR(DATETIME)
HAVING HOUR >= '9' AND HOUR <= '19'
ORDER BY HOUR

실행 결과