---

INSERT INTO Reviews (id, reservation_id, rating)
VALUES (
    (SELECT COUNT(*) + 1 FROM Reviews r),
    (
        SELECT Reservations.id
        FROM Reservations
        JOIN Users ON Reservations.user_id = Users.id
        JOIN Rooms ON Reservations.room_id = Rooms.id
        WHERE Users.name = 'George Clooney'
          AND Rooms.address = '11218, Friel Place, New York'
    ),
    5
);