SELECT user_id, g.room_id, room_type, DATEDIFF(checkout_time, c.checkin_time) AS days FROM checkin_tb c JOIN guestroom_tb g ON c.room_id = g.room_id WHERE MONTH(checkin_time) > 5 AND DAY(checkin_time) > 11 HAVING days > 1 ORDER BY days, room_id, user_id desc