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

WITH t1 AS (
    SELECT a.user_id,
           a.room_id,
           b.room_type,
           DATE(checkout_time)-DATE(checkin_time) AS days
    FROM checkin_tb a
    LEFT JOIN guestroom_tb b
    ON a.room_id = b.room_id
    WHERE DATE(checkin_time) = '2022-06-12'
    HAVING days >= 2
    ORDER BY days ASC,room_id ASC ,user_id DESC
)
SELECT * FROM t1;

# 这里的细节是：入住多晚代表 days>=2 !