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

SELECT t2.user_id,t2.room_id,t1.room_type,DATEDIFF(t2.checkout_time,t2.checkin_time) AS days
FROM guestroom_tb t1
LEFT JOIN checkin_tb t2 ON t1.room_id=t2.room_id
WHERE DATE(t2.checkin_time)='2022-06-12' AND 
      DATEDIFF(t2.checkout_time,t2.checkin_time)>=2
ORDER BY days,room_id,user_id DESC