题解 | #查询连续入住多晚的客户信息?#
查询连续入住多晚的客户信息?
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
select user_id,g.room_id,room_type ,datediff(checkout_time,checkin_time) days from guestroom_tb g join checkin_tb c on g.room_id = c.room_id where datediff(checkout_time,checkin_time) >=2 order by datediff(checkout_time,checkin_time),g.room_id,c.user_id desc