[Lv.2] 입양 시각 구하기(1) [EXTRACT, BETWEEN]

 

 

문제 해결을 위한 개념 정리 

 

✅ BETWEEN

https://seheehee.tistory.com/29

가격대 별 상품 개수 구하기 [case when, between]

 

✅ EXTRACT

https://seheehee.tistory.com/58

진료과별 총 예약 횟수 출력하기[EXTRACT]

 

 

문제 해결 코드

SELECT EXTRACT(HOUR FROM DATETIME) AS `HOUR`, COUNT(ANIMAL_ID) AS `COUNT`
FROM ANIMAL_OUTS
WHERE EXTRACT(HOUR FROM DATETIME) BETWEEN 9 AND 19
GROUP BY `HOUR`
ORDER BY `HOUR` ASC;