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

SELECT
    user_id,
    ct.room_id,
    room_type,
    DATEDIFF(DATE(checkout_time), DATE(checkin_time)) AS days
FROM
    checkin_tb ct
    LEFT JOIN guestroom_tb gt ON ct.room_id = gt.room_id
WHERE
    DATEDIFF(DATE(checkout_time), DATE(checkin_time)) >= 2
ORDER BY
    days,
    room_id,
    user_id desc;