Загрузка данных

SELECT 
    Reservations.room_id AS room_id,
    Users.name AS name,
    Reservations.end_date AS end_date
FROM Reservations
JOIN Users ON Reservations.user_id = Users.id
WHERE (Reservations.room_id, Reservations.end_date) IN (
    SELECT room_id, MAX(end_date)
    FROM Reservations
    GROUP BY room_id
);