프로그래머스 - 입양 시각 구하기(1)

문제 : https://programmers.co.kr/learn/courses/30/lessons/59412

프로그래머스

 

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

view raw .SQL hosted with ❤ by GitHub