select c.user_id,c.room_id,g.room_type,datediff(c.checkout_time,c.checkin_time) days
from checkin_tb c join guestroom_tb g using(room_id)
where datediff(c.checkout_time,c.checkin_time)>1
order by days,c.room_id,c.user_id desc