1
2
3
4
5
6
7
8
-- 코드를 입력하세요
SELECT hour, count(*)
FROM 
    (SELECT TO_CHAR(datetime,'HH24') AS hour
     FROM animal_outs)
WHERE hour BETWEEN 09 AND 19
GROUP BY hour
ORDER BY hour;