[대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기 프로그래머스] - Level3 Oracle 풀이

https://school.programmers.co.kr/learn/courses/30/lessons/151139

프로그래머스

 

-- 코드를 입력하세요
SELECT to_char(to_date(A.month,'MM'),'FMMM') as MONTH,A.car_id,count(*) as RECORDS FROM 
    ( 
    	SELECT to_char(start_date,'MM') as MONTH,history_id,car_id  FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY 
        WHERE CAR_ID in
             ( SELECT  car_id  from CAR_RENTAL_COMPANY_RENTAL_HISTORY  
                WHERE TO_CHAR(START_DATE, 'YYYY-MM') BETWEEN '2022-08' AND '2022-10'
                GROUP BY CAR_ID
                HAVING COUNT(*) >= 5 )
     				and    TO_CHAR(START_DATE, 'YYYY-MM') BETWEEN '2022-08' AND '2022-10'
) A
group by  MONTH,car_id
ORDER BY A.month ASC,A.CAR_ID DESC

 

오라클에서 날짜 구간 비교할때는 무조껀 TO_CHAR  , Between !!!!