题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
WITH occupy AS( SELECT user_id, g.room_id, room_type, datediff(checkout_time, checkin_time) days FROM guestroom_tb g JOIN checkin_tb c ON g.room_id = c.room_id WHERE year(checkin_time) = 2022 AND month(checkin_time) = 6 AND day(checkin_time) = 12 ) SELECT user_id, room_id, room_type, days FROM occupy WHERE days > 1 ORDER BY days, room_id, user_id DESC
查看14道真题和解析