[프로그래머스, 59412] 입양 시각 구하기(1) (mysql)

https://school.programmers.co.kr/learn/courses/30/lessons/59412

프로그래머스

728x90

---

SELECT date_format(datetime, '%H') as HOUR, count(animal_id) as COUNT
FROM animal_outs
GROUP BY HOUR
HAVING HOUR >= 9 and HOUR <= 19
ORDER BY HOUR