[프로그래머스] 자동차 대여 기록에서 장기/단기 대여 구분하기

문제

---

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

정답

---

-- 코드를 입력하세요
SELECT 
	history_id as HISTORY_ID
	, car_id as CAR_ID
	, to_char(start_date, 'yyyy-mm-dd') as START_DATE
	, to_char(end_date, 'yyyy-mm-dd') as END_DATE
	, case when (end_date - start_date+1)>=30
		then '장기 대여'
		else '단기 대여'
	  end as RENT_TYPE
from car_rental_company_rental_history
where 
	start_date >= to_date('20220901', 'yyyy-mm-dd') 
	and start_date < to_date('20221001', 'yyyy-mm-dd')
order by history_id desc;