입양 시각 구하기(1)

윤지현·2024년 6월 21일

SQL(Programmers)

목록 보기
26/184
SELECT HOUR(DATETIME) HOUR,
        COUNT(DATETIME)
FROM ANIMAL_OUTS 
WHERE HOUR(DATETIME) BETWEEN 9 AND 19
GROUP BY 1
ORDER BY 1
SELECT DATE_FORMAT(DATETIME, '%H') HOUR,
        COUNT(DATETIME)
FROM ANIMAL_OUTS 
WHERE DATE_FORMAT(DATETIME, '%H') BETWEEN 9 AND 19
GROUP BY 1
ORDER BY 1
profile
첫 시작

0개의 댓글