题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
select
user_id,
c.room_id,
room_type,
datediff(left(checkout_time,10),left(checkin_time,10)) as days
from checkin_tb c
left join guestroom_tb g on c.room_id=g.room_id
where datediff(left(checkout_time,10),left(checkin_time,10))>1
order by days,c.room_id,user_id desc
;
投递美团等公司8个岗位