[프로그래머스 / SQL 고득점 Kit] 대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기

📄 문제

 

💡 풀이

<Oracle>

SELECT EXTRACT(MONTH from start_date) month, car_id, COUNT(*) records
FROM car_rental_company_rental_history
WHERE TO_DATE('2022-08-01','yyyy-MM-dd') <= start_date 
	AND start_date < TO_DATE('2022-11-01','yyyy-MM-dd')
	AND car_id IN ( SELECT car_id
                FROM car_rental_company_rental_history
                WHERE TO_DATE('2022-08-01','yyyy-MM-dd') <= start_date 
                	AND start_date < TO_DATE('2022-11-01','yyyy-MM-dd')
                GROUP BY car_id
                HAVING COUNT(*) >= 5 )
GROUP BY EXTRACT(MONTH from start_date), car_id
ORDER BY month, car_id DESC