题解 | 查询连续入住多晚的客户信息？

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