강의로 돌아가기
-

Oracle 정답 (TO_CHAR & SUBQUERY 사용)

-- 코드를 입력하세요
SELECT hour, count(*)
FROM
(SELECT TOCHAR(datetime,'HH24') AS hour
FROM animal
outs)
WHERE hour BETWEEN 09 AND 19
GROUP BY hour
ORDER BY hour;

작성중인 코드―solution.sql
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;
0 개의 답변
답변 쓰기
This input form supports markdown syntax. Please refer to 마크다운 가이드.