Could you add in the rates they paid to the table please? | Sorry, did you mean the base price of the room? | The reservation rate, please
SELECT T1.firstname ,  T1.lastname, T1.Rate FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room   =   T2.RoomId WHERE T1.Rate - T2.basePrice  >  0
rates they paid refers to Rate in Reservations table; reservation rate refers to the rate at which the reservation was made; JOIN operation is used to combine information from Reservations and Rooms tables based on RoomId; filtering WHERE T1.Rate - T2.basePrice > 0 to find reservations where the rate paid is more than the base price of the room;