题解 | 查询连续入住多晚的客户信息?
查询连续入住多晚的客户信息?
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
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
查看2道真题和解析