알고리즘/SQL

[프로그래머스 SQL] 입양 시각 구하기

빙빙 2021. 7. 1. 10:51
SELECT HOUR(DATETIME) AS 'HOUR',COUNT(HOUR(DATETIME)) AS 'COUNT'
FROM ANIMAL_OUTS
where HOUR(DATETIME) >= 9 AND HOUR(DATETIME) < 20
GROUP BY HOUR(DATETIME)
ORDER BY HOUR(DATETIME) ASC;