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

SELECT date_format(DATETIME,'%H') AS HOUR, COUNT(ANIMAL_ID) as COUNT
FROM ANIMAL_OUTS
WHERE date_format(DATETIME,'%H') BETWEEN '08:00' AND '19:59'
group by hour
order by hour;

 

다른사람은 어떻게 풀었는지 비교하기