select
t1.user_id  user_id  
,t1.room_id room_id
,t2.room_type room_type
,datediff(t1.checkout_time,t1.checkin_time) days 
from checkin_tb t1
join guestroom_tb t2
on t1.room_id = t2.room_id
where left(checkin_time,10) >= '2022-06-12' and datediff(t1.checkout_time,t1.checkin_time) >1
order by 4,2,1 desc