[프로그래머스] 특정 기간동안 대여 가능한 자동차들의 대여 비용 구하기

SELECT C1.CAR_ID, C1.CAR_TYPE,
ROUND(C1.DAILY_FEE*30*(100-C3.DISCOUNT_RATE)/100) AS FEE
FROM CAR_RENTAL_COMPANY_CAR C1 
JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY C2 ON C1.CAR_ID = C2.CAR_ID
JOIN CAR_RENTAL_COMPANY_DISCOUNT_PLAN C3 ON C1.CAR_TYPE = C3.CAR_TYPE
WHERE C1.CAR_ID NOT IN (SELECT CAR_ID
                        FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY 
                        WHERE START_DATE <'22-12-01'
                        AND END_DATE >'2022-11-01') 
AND C3.DURATION_TYPE='30일 이상'
AND C1.CAR_TYPE IN ('세단','SUV')

GROUP BY C1.CAR_ID
HAVING FEE >=500000 AND FEE <=2000000
ORDER BY FEE DESC, CAR_TYPE, CAR_ID DESC;