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

🤔 문제

✅ 정답

SELECT HOUR(DATETIME) AS HOUR, COUNT(HOUR(DATETIME)) AS COUNT
FROM ANIMAL_OUTS
GROUP BY HOUR
HAVING HOUR BETWEEN 9 AND 19
ORDER BY HOUR