题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
SELECT c.user_id, c.room_id, g.room_type, c.days FROM (SELECT user_id, room_id, datediff(checkout_time,checkin_time) AS days FROM checkin_tb where datediff(checkout_time,checkin_time) >1 ) c JOIN (SELECT room_id, room_type FROM guestroom_tb ) g ON c.room_id = g.room_id order by days, room_id, user_id DESC
查看20道真题和解析
