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