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

SELECT
    user_id,
    c.room_id,
    room_type,
    datediff (checkout_time, checkin_time) as days
FROM
    checkin_tb c
    LEFT JOIN guestroom_tb g ON c.room_id = g.room_id
WHERE
    date_format (checkin_time, '%Y-%m-%d') = '2022-06-12'
    AND datediff (checkout_time, checkin_time) > 1
    order by 4,2,1 desc 

1. 连接表，获取房间信息
2. where限制过滤
3. datediff 函数，date_format函数使用