알고리즘/프로그래머스
(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)