코딩연습이 좋아서/SQL이 좋아서
입양 시각 구하기(1)
zoaseo
2025. 2. 3. 23:03
SELECT HOUR(DATETIME) AS HOUR,
COUNT(*) AS COUNT
FROM ANIMAL_OUTS
GROUP BY HOUR
HAVING HOUR >= 9 AND HOUR <= 19
ORDER BY HOUR;