zimslog

프로그래머스 - 특정 기간동안 대여 가능한 자동차들의 대여비용 구하기 1. 처음 정답 코드WITH PLIST AS (SELECT *FROM CAR_RENTAL_COMPANY_CAR CWHERE C.CAR_TYPE IN ('세단','SUV') AND C.CAR_ID NOT IN (SELECT H.CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY H WHERE NOT (END_DATE '2022-11-30')) ) SELECT L.CAR_ID AS CAR_ID, L.CAR_TYPE AS CAR_TYPE, ROUND(L.DAILY_FEE*30..