题解 | 查询连续入住多晚的客户信息？

select distinct

t1.user_id

,t1.room_id

,t2.room_type

,dateDIFF(t1.checkout_time,t1.checkin_time) as days

from checkin_tb as t1

LEFT join guestroom_tb as t2

on t1.room_id = t2.room_id

where dateDIFF(t1.checkout_time,t1.checkin_time) >= 2

and date_format(checkin_time,'YYYY-MM-DD') >= '2022-06-12'

order by days asc,t1.room_id asc;

这样写更完整！