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

SELECT user_id,room_id, room_type, TIMESTAMPDIFF(DAY,checkin_time,checkout_time)+1 AS days
FROM checkin_tb
JOIN guestroom_tb USING(room_id)
HAVING days>1
ORDER BY days, room_id, user_id DESC

入住天数可以直接用TIMESTAMPDIFF+1的方式实现，要求连续入驻的，在此基础上用having添加条件即可