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

select user_id, room_id, room_type, datediff (checkout_time,checkin_time) as days
from checkin_tb
join guestroom_tb using(room_id)
where  datediff(checkout_time,checkin_time) > 1
order by days, room_id, user_id desc

这题又有问题