문제
풀이
select hour(datetime) as hour, count(*) from animal_outs
group by hour having hour >= 9 and hour <= 19 order by hour;
'algorithm' 카테고리의 다른 글
[programmers] MySQL - Lv.2 NULL 처리하기 (is null) (0) | 2022.08.22 |
---|---|
[HackerRank] MySQL - Weather Observation Station 5 (0) | 2022.08.21 |
[HackerRank] MySQL - Weather Observation Station 4 (0) | 2022.08.17 |
[programmers] MySQL - Lv.2 동물 수 구하기 (sum, max, min) (0) | 2022.08.17 |
[HackerRank] MySQL - Weather Observation Station 3 (0) | 2022.08.12 |