[프로그래머스] SQL kit | 입양 시각 구하기(1)

SOLUTION

SELECT HOUR(DATETIME) AS HOUR, COUNT(DATETIME) AS COUNT
FROM ANIMAL_OUTS
WHERE DATETIME
GROUP BY HOUR(DATETIME)
HAVING HOUR >=9 AND HOUR <=19
ORDER BY HOUR(DATETIME) ASC

 

- HOUR

- HAVING