题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
select user_id,gt.room_id,room_type,days from( select user_id,room_id,date(checkout_time)-date(checkin_time) days from checkin_tb where checkin_time >= '2022-06-12') as t1 join guestroom_tb gt on t1.room_id = gt.room_id where days > 1 order by days,room_id,user_id desc
