본문 바로가기

algorithm

[programmers] MySQL - Lv.2 입양 시각 구하기(1) (group by)

문제

 

 

 

 

풀이

 

select hour(datetime) as hour, count(*) from animal_outs
group by hour having hour >= 9 and hour <= 19 order by hour;