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

select
    user_id,
    c.room_id,
    room_type,
    days
from (
    select
        user_id,
        room_id,
        datediff(checkout_time, checkin_time) days
    from
        checkin_tb 
    where date(checkin_time)>='2022-06-12'
) c
left join guestroom_tb g on c.room_id=g.room_id
where days>1
order by days, c.room_id, user_id desc