알고리즘
[SQL]프로그래머스 Lv.4 자동차 대여 기록별 대여 금액 구하기
✅ 코드 WITH RENTAL_HISTORY AS ( SELECT * , CASE WHEN DATEDIFF(END_DATE, START_DATE) + 1 < 7 THEN NULL WHEN DATEDIFF(END_DATE, START_DATE) + 1 < 30 THEN '7일 이상' WHEN DATEDIFF(END_DATE, START_DATE) + 1 < 90 THEN '30일 이상' ELSE '90일 이상' END AS DURATION_TYPE FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY ), TRUCKS AS ( SELECT * FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = '트럭' ) SELECT H.HISTORY_ID AS HISTORY_..
