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