-- 코드를 입력하세요
SELECT hour, count(*)
FROM
(SELECT TOCHAR(datetime,'HH24') AS hour
FROM animalouts)
WHERE hour BETWEEN 09 AND 19
GROUP BY hour
ORDER BY hour;
작성중인 코드―solution.sql
1
2
3
4
5
6
7
8
-- 코드를 입력하세요SELECThour,count(*)FROM(SELECTTO_CHAR(datetime,'HH24')AShourFROManimal_outs)WHEREhourBETWEEN09AND19GROUPBYhourORDERBYhour;