题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
SELECT user_id,
room_id,
room_type,
DATEDIFF(checkout_time,checkin_time) AS days
FROM checkin_tb
LEFT JOIN guestroom_tb USING(room_id)
WHERE DATE(checkin_time) = '2022-06-12' AND DATEDIFF(checkout_time,checkin_time) > 1
ORDER BY days ASC, room_id ASC, user_id DESC
