题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
select user_id, room_id, room_type, datediff(checkout_time,checkin_time) as days from checkin_tb left join guestroom_tb using(room_id) where checkin_time>='2022-06-12' having days>1 order by 4,2,1 desc
查看11道真题和解析