프로그래머스 Oracle : 특정 기간동안 대여 가능한 자동차들의 대여비용 구하기
문제 설명 문제정답select c.car_id, c.car_type, (c.daily_fee*((100-d.DISCOUNT_RATE)/100))*30 as feefrom ( SELECT a.car_id, a.car_type, a.daily_fee from CAR_RENTAL_COMPANY_CAR a where a.car_id not in ( select car_id from CAR_RENTAL_COMPANY_RENTAL_HISTORY where to_char(START_DATE, 'YYYYMMDD') = '20221101' ) and a.CAR_TYPE in ('세단','SUV') ) c,CAR_RENTAL_COMPANY_DISCOUNT_PLAN dwhere c.CA..
2025.01.21