[Programmers SQL 고득점 Kit] GROUP BY [3/4] 입양 시각 구하기(1)

문제 link
https://programmers.co.kr/learn/courses/30/lessons/59412

Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/03_GROUP_BY/GROUP_BY-3.sql

SELECT HOUR(DATETIME) AS HOUR, COUNT(ANIMAL_ID) AS COUNT
FROM ANIMAL_OUTS
GROUP BY HOUR
HAVING HOUR >= 9 AND HOUR < 20
ORDER BY HOUR