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

Hi, There!
안녕하세요, 바오밥입니다.

 

 

---

목차

• 문제
• 풀이

 

---

문제

문제 내용

https://school.programmers.co.kr/learn/courses/30/lessons/157339

프로그래머스

 

---

풀이

나의 풀이

- DBMS : Oracle 기준

SELECT 
    CC.CAR_ID CAR_ID, 
    CC.CAR_TYPE CAR_TYPE, 
    ROUND((CC.DAILY_FEE * (100-DISCOUNT_RATE)/100 * 30), 0) FEE 
    
FROM
    CAR_RENTAL_COMPANY_CAR CC, 
    CAR_RENTAL_COMPANY_DISCOUNT_PLAN CDP 

WHERE 
    CC.CAR_TYPE IN ('SUV', '세단')
    AND CC.CAR_ID NOT IN (
        SELECT CAR_ID 
        FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
        WHERE TO_DATE('2022-11', 'YYYY-MM') BETWEEN START_DATE AND END_DATE ) 
    AND CC.CAR_TYPE = CDP.CAR_TYPE
    AND DURATION_TYPE = '30일 이상'
    AND ROUND((CC.DAILY_FEE * (100-DISCOUNT_RATE)/100 * 30), 0) BETWEEN 500000 AND 2000000

ORDER BY
    FEE DESC,
    CAR_TYPE,
    CAR_ID DESC