알고리즘/프로그래머스

(MySQL) 프로그래머스 - 입양 시각 구하기(1)

소갱 2021. 9. 26. 12:20
SELECT HOUR(DATETIME) AS 'HOUR', COUNT(*) AS 'COUNT'
FROM ANIMAL_OUTS
WHERE HOUR(DATETIME) BETWEEN 9 AND 19
GROUP BY HOUR(DATETIME)
ORDER BY HOUR(DATETIME)