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

select 
    user_id,
    c.room_id,
    room_type,
    datediff(left(checkout_time,10),left(checkin_time,10)) as days
from checkin_tb c
left join guestroom_tb g on c.room_id=g.room_id
where datediff(left(checkout_time,10),left(checkin_time,10))>1
order by days,c.room_id,user_id desc
;