题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
select
A.user_id,
A.room_id,
B.room_type,
(DATE(A.checkout_time)-DATE(A.checkin_time)) AS days
from
checkin_tb as A
left join guestroom_tb as B ON A.room_id = B.room_id
where DATE(A.checkin_time) = '2022-06-12'
and (DATE(A.checkout_time)-DATE(A.checkin_time)) > 1
order by (DATE(A.checkout_time)-DATE(A.checkin_time)) asc ,A.room_id asc ,A.user_id desc
查看22道真题和解析