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

728x90

SELECT date_format(datetime, '%H') as hour, count(*) as count
from animal_outs
group by hour
having hour >= 9 and hour < 20
order by hour