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

SELECT
    ct.user_id,
    ct.room_id,
    gt.room_type,
    DATEDIFF(ct.checkout_time, ct.checkin_time) AS days
FROM
    checkin_tb ct
    JOIN guestroom_tb gt USING (room_id)
WHERE
    ct.checkin_time > 06 -12
    AND DATEDIFF(ct.checkout_time, ct.checkin_time) > 1
GROUP BY
    room_id,
    user_id,
    room_type,
    days
ORDER BY
    days ASC,
    room_id ASC,
    user_id DESC