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

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

프로그래머스

---

SELECT TO_CHAR(DATETIME , 'HH24') AS HOUR, COUNT(*)
FROM ANIMAL_OUTS
WHERE TO_CHAR(DATETIME , 'HH24') >= 9 
    AND TO_CHAR(DATETIME , 'HH24') <= 19
GROUP BY TO_CHAR(DATETIME , 'HH24')
ORDER BY TO_CHAR(DATETIME , 'HH24');