MySQL 문제출기(프로그래머스)

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

프로그래머스

SELECT BOARD_ID, WRITER_ID,	TITLE, PRICE, if(status = 'SALE', "판매중", 
                                             if(status = 'RESERVED', '예약중', '거래완료')) as status	
from USED_GOODS_BOARD
where date_format(CREATED_DATE, "%Y-%m-%d") = "2022-10-05"
order by board_id desc

 

 

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

프로그래머스

SELECT car_id, round(avg(DATEDIFF(END_DATE,START_DATE)+1),1) as AVERAGE_DURATION
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
group by car_id
having avg(DATEDIFF(END_DATE,START_DATE)+1) >= 7
order by AVERAGE_DURATION desc, car_id desc