题解 | 查询连续入住多晚的客户信息？
select user_id,room_id,room_type,datediff(checkout_time,checkin_time) as days from checkin_tb a left join guestroom_tb b 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
海康威视公司氛围 471人发布