SELECT HOUR(DATETIME) as "HOUR" , count(*) as "COUNT"
from ANIMAL_OUTS
group by HOUR
having HOUR between 9 and 19
order by hour(DATETIME)
'[SQL]' 카테고리의 다른 글
[프로그래머스,SQL,NULL] #9.NULL 처리하기 (0) | 2020.05.21 |
---|---|
[프로그래머스,SQL,group by,LEVEL4] #8.입양시각구하기(2) (0) | 2020.05.21 |
[프로그래머스,SQL,Group by] #7.동명동물찾기 (0) | 2020.05.21 |
[프로그래머스,SQL,SELECT] #4.어린동물찾기 (0) | 2020.05.21 |
[프로그래머스,SQL,SELECT] #3. 아픈동물찾기 (0) | 2020.05.21 |