select user_id, c.room_id, room_type, datediff(checkout_time, checkin_time) as days
from checkin_tb c join guestroom_tb j on c.room_id = j.room_id
where date(checkin_time) >= "2022-06-12 00:00:00" 
having days > 1
order by days, room_id, user_id desc