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