题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
select user_id,
room_id,
room_type,
days
from(
select user_id,room_id,
ceil(timestampdiff(hour,checkin_time,checkout_time)/24) as days
from checkin_tb
where timestampdiff(hour,checkin_time,checkout_time)/24>1
) a
join guestroom_tb
using(room_id)
order by days ,room_id,user_id desc
