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

프로그래머스

 

📝 Language: Oracle

 

  SELECT TO_CHAR(DATETIME, 'FMHH24') HOUR, 
         COUNT(*) COUNT
    FROM ANIMAL_OUTS
GROUP BY TO_CHAR(DATETIME, 'FMHH24')
  HAVING TO_CHAR(DATETIME, 'FMHH24') >= 9 
     AND TO_CHAR(DATETIME, 'FMHH24') < 20
ORDER BY TO_NUMBER(TO_CHAR(DATETIME, 'FMHH24'))
;
 

🙂 확인 사항

1. ANIMAL_OUTS 테이블

2. 09:00부터 19:59까지,

3. 각 시간대별로 입양이 몇 건이나 발생했는지 조회

4. 시간대 순 정렬

 

😮 이 외의 풀이

WITH SUB AS (
    SELECT TO_CHAR(DATETIME, 'FMHH24') HOUR
      FROM ANIMAL_OUTS
     WHERE TO_NUMBER(TO_CHAR(DATETIME, 'FMHH24')) BETWEEN 9 AND 19
)
  SELECT HOUR, 
         COUNT(HOUR) COUNT
    FROM SUB
GROUP BY HOUR
ORDER BY TO_NUMBER(HOUR)
;
 

공통 표현식 사용

 

WITH SUB AS (
      SELECT TO_CHAR(DATETIME, 'FMHH24') AS HOUR,
             COUNT(*) AS COUNT
        FROM ANIMAL_OUTS
    GROUP BY TO_CHAR(DATETIME, 'FMHH24')
)
  SELECT HOUR, COUNT
    FROM SUB
   WHERE HOUR BETWEEN 9 AND 19
ORDER BY TO_NUMBER(HOUR)
;
 

공통 표현식 사용

 

 

 

🔗 소스 코드
GitHub