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