-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical room rates and occupancy patterns in a mid-range inn, ensuring that the rates are competitive yet profitable, and that the length of stay reflects common booking durations.

-- Realistic data for Reservations
INSERT INTO Reservations (ReservationId, Rate, RoomId) VALUES (1, 120.0, 101);
INSERT INTO Reservations (ReservationId, Rate, RoomId) VALUES (2, 150.0, 102);
INSERT INTO Reservations (ReservationId, Rate, RoomId) VALUES (3, 200.0, 103);

-- Realistic data for ReservationDurations
INSERT INTO ReservationDurations (ReservationId, LengthOfStay) VALUES (1, 2);
INSERT INTO ReservationDurations (ReservationId, LengthOfStay) VALUES (2, 3);
INSERT INTO ReservationDurations (ReservationId, LengthOfStay) VALUES (3, 5);

