SELECT H.HISTORY_ID, FLOOR( (DATEDIFF(H.END_DATE, H.START_DATE) + 1) * C.DAILY_FEE * (1 - IFNULL(P.DISCOUNT_RATE, 0) / 100) ) AS FEEFROM CAR_RENTAL_COMPANY_CAR CJOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY H ON C.CAR_ID = H.CAR_IDLEFT JOIN CAR_RENTAL_COMPANY_DISCOUNT_PLAN P ON C.CAR_TYPE = P.CAR_TYPE AND ( (DATEDIFF(H.END_DATE, H.START_DATE) + 1 >= 90..