题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
SELECT
user_id,
g.room_id,
room_type,
DATEDIFF(checkout_time, c.checkin_time) AS days
FROM checkin_tb c JOIN guestroom_tb g
ON c.room_id = g.room_id
WHERE MONTH(checkin_time) > 5 AND DAY(checkin_time) > 11
HAVING days > 1
ORDER BY days, room_id, user_id desc
，面试的会议约了多长时间呀