programmers | sql

💡 MySQL

🔗 문제

입양 시각 구하기(1)
[Link]

💻 코드

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

참고 자료

[프로그래머스] 입양 시각 구하기(1), (2) (GROUP BY, HAVING, SET)