https://school.programmers.co.kr/learn/courses/30/lessons/59412
SELECT DATE_FORMAT(DATETIME,"%H") AS HOUR, COUNT(*) AS COUNT
FROM ANIMAL_OUTS
GROUP BY DATE_FORMAT(DATETIME,"%H")
HAVING HOUR > 8 AND HOUR < 20
ORDER BY HOUR
SELECT
HOUR(DATETIME) AS HOUR,
COUNT(*) AS COUNT
FROM ANIMAL_OUTS
WHERE HOUR(DATETIME) BETWEEN 9 AND 19
GROUP BY HOUR
ORDER BY HOUR;
'Problem Solving > SQL' 카테고리의 다른 글
루시와 엘라 찾기(특정 이름 찾기) (0) | 2023.11.24 |
---|---|
3월에 태어난 여성 회원 목록 출력하기(DATE) (1) | 2023.11.24 |
고양이와 개의 수(GROUP BY, HAVING) (1) | 2023.11.24 |
카테고리 별 상품 개수 구하기(문자열자르기, LEFT()) (0) | 2023.11.24 |
중성화여부(IF, CASE WHEN) (0) | 2023.11.24 |