select user_id,g.room_id,room_type,datediff(checkout_time,checkin_time) as days
from checkin_tb c left join guestroom_tb g on c.room_id=g.room_id
where datediff(checkout_time,checkin_time)>1 and checkin_time>'2022-06-12'
order by datediff(checkout_time,checkin_time),g.room_id,user_id desc