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

select user_id,
room_id,
room_type,
days 
from(
    select user_id,room_id,
    ceil(timestampdiff(hour,checkin_time,checkout_time)/24) as days 
    from checkin_tb 
    where timestampdiff(hour,checkin_time,checkout_time)/24>1
) a 
join guestroom_tb 
using(room_id)
order by days ,room_id,user_id desc