题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
with t as(
select
ct.room_id,
ct.user_id,
gt.room_type,
datediff(checkout_time,checkin_time) days
from checkin_tb ct left join guestroom_tb gt on ct.room_id = gt.room_id
where checkin_time>= '2022-06-12'
)
select
user_id,
room_id,
room_type,
days
from t
where days > 1
order by days asc, room_id asc,user_id desc
