with room_checkin as(
select user_id,
       a.room_id as room_id,
       room_type,
       datediff(date(checkout_time),date(checkin_time)) as days
from guestroom_tb a right join checkin_tb b on a.room_id=b.room_id)


select user_id,
room_id,
room_type,
days
from room_checkin
where days>1
order by days,room_id,user_id desc