题解 | 查询连续入住多晚的客户信息?
SELECT ct.user_id, ct.room_id, gt.room_type, DATEDIFF(checkout_time,checkin_time) days FROM guestroom_tb gt JOIN checkin_tb ct ON ct.room_id = gt.room_id WHERE DATEDIFF(checkout_time,checkin_time)>1 ORDER BY days, ct.room_id, ct.user_id DESC

