[My_SQL, Lv.3]대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기

프로그래머스

WITH TEMP AS(
SELECT MONTH(START_DATE) AS MONTH,
        CAR_ID,
        COUNT(*) AS RECORDS
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY 
WHERE DATE_FORMAT(START_DATE,'%Y-%m') BETWEEN '2022-08' AND '2022-10'
GROUP BY MONTH, CAR_ID)

SELECT * 
FROM TEMP 
WHERE CAR_ID IN (SELECT CAR_ID 
                FROM TEMP
                GROUP BY CAR_ID
                HAVING SUM(RECORDS) >= 5) -- KEY POINT! 총 기간 동안 대여 횟수가 5회 이상인 자동차만 출력하기 위함 
ORDER BY MONTH ASC, CAR_ID DESC