CREATE TABLE Room_reservation (
    reservation_id INT PRIMARY KEY,
    guest_id INT,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    check_in_date DATE,
    check_out_date DATE,
    room_number INT,
    room_type VARCHAR(50),
    adults INT,
    hotel_name VARCHAR(100),
    price_per_night VARCHAR(20)
);


INSERT INTO Room_reservation VALUES 
(301, 1, 'John', 'Wick', '2023-09-15', '2023-09-20', 101, 'Deluxe', 1, 'Ocean Breeze Resort', '₱7,500'),
(302, 2, 'Sabbine', 'Callas', '2023-10-01', '2023-10-05', 102, 'Standard', 2, 'Emerald Heights Hotel', '₱10,000'),
(303, 3, 'Liam', 'Byrne', '2023-11-10', '2023-11-15', 103, 'Suite', 3, 'Sunset Serenity Inn', '₱13,500'),
(304, 4, 'Jaymie', 'Adeyemi', '2023-12-01', '2023-12-05', 104, 'Deluxe', 4, 'Tropical Oasis Lodge', '₱8,500'),
(305, 5, 'Tayane', 'Alvez', '2023-12-20', '2023-12-20', 105, 'Deluxe', 5, 'Pearl Paradise Suites', '₱9,000'),
(306, 6, 'Klara', 'Bohringer', '2023-01-05', '2023-01-10', 106, 'Standard', 6, 'Skyline Grand Hotel', '₱15,000'),
(307, 7, 'Erik', 'Torsten', '2023-02-14', '2023-02-19', 107, 'Deluxe', 7, 'Bamboo Bliss Inn', '₱25,000'),
(308, 8, 'Vincent', 'Fabron', '2023-03-01', '2023-03-06', 108, 'Standard', 8, 'Golden Sands Resort', '₱18,000'),
(309, 9, 'Kirra', 'Foster', '2023-03-15', '2023-03-20', 109, 'Deluxe', 9, 'Mountain View Retreat', '₱32,000'),
(310, 10, 'Joseph', 'Joestar', '2023-04-01', '2023-04-06', 110, 'Deluxe', 10, 'Azure Dreams Hotel', '₱12,000'),
(311, 11, 'John', 'Wick', '2023-09-15', '2023-09-20', 111, 'Standard', 11, 'Ocean Breeze Resort', '₱9,000'),
(312, 12, 'Sabbine', 'Callas', '2023-10-01', '2023-10-05', 112, 'Deluxe', 12, 'Emerald Heights Hotel', '₱12,000'),
(313, 13, 'Liam', 'Byrne', '2023-11-10', '2023-11-15', 113, 'Deluxe', 13, 'Sunset Serenity Inn', '₱12,000'),
(314, 14, 'Jaymie', 'Adeyemi', '2023-12-01', '2023-12-05', 114, 'Deluxe', 14, 'Tropical Oasis Lodge', '₱7,500'),
(315, 15, 'Tayane', 'Alvez', '2023-12-20', '2023-12-20', 115, 'Suite', 15, 'Pearl Paradise Suites', '₱9,000'),
(316, 16, 'Klara', 'Bohringer', '2023-01-05', '2023-01-10', 116, 'Suite', 16, 'Skyline Grand Hotel', '₱12,000'),
(317, 17, 'Erik', 'Torsten', '2023-02-14', '2023-02-19', 117, 'Deluxe', 17, 'Bamboo Bliss Inn', '₱32,000'),
(318, 18, 'Vincent', 'Fabron', '2023-03-01', '2023-03-06', 118, 'Deluxe', 18, 'Golden Sands Resort', '₱7,500'),
(319, 19, 'Kirra', 'Foster', '2023-03-15', '2023-03-20', 119, 'Suite', 19, 'Mountain View Retreat', '₱9,000'),
(320, 20, 'Joseph', 'Joestar', '2023-04-01', '2023-04-06', 120, 'Deluxe', 20, 'Azure Dreams Hotel', '₱12,000'),
(321, 21, 'John', 'Wick', '2023-09-15', '2023-09-20', 121, 'Deluxe', 21, 'Ocean Breeze Resort', '₱9,000'),
(322, 22, 'Sabbine', 'Callas', '2023-10-01', '2023-10-05', 122, 'Suite', 22, 'Emerald Heights Hotel', '₱8,500'),
(323, 23, 'Liam', 'Byrne', '2023-11-10', '2023-11-15', 123, 'Deluxe', 23, 'Sunset Serenity Inn', '₱32,000'),
(324, 24, 'Jaymie', 'Adeyemi', '2023-12-01', '2023-12-05', 124, 'Standard', 24, 'Tropical Oasis Lodge', '₱12,000'),
(325, 25, 'Tayane', 'Alvez', '2023-12-20', '2023-12-20', 125, 'Deluxe', 25, 'Pearl Paradise Suites', '₱7,500'),
(326, 26, 'Klara', 'Bohringer', '2023-01-05', '2023-01-10', 126, 'Deluxe', 26, 'Skyline Grand Hotel', '₱9,000'),
(327, 27, 'Erik', 'Torsten', '2023-02-14', '2023-02-19', 127, 'Standard', 27, 'Bamboo Bliss Inn', '₱7,500'),
(328, 28, 'Vincent', 'Fabron', '2023-03-01', '2023-03-06', 128, 'Suite', 28, 'Golden Sands Resort', '₱9,000'),
(329, 29, 'Kirra', 'Foster', '2023-03-15', '2023-03-20', 129, 'Deluxe', 29, 'Mountain View Retreat', '₱15,000'),
(330, 30, 'Joseph', 'Joestar', '2023-04-01', '2023-04-06', 130, 'Standard', 30, 'Azure Dreams Hotel', '₱8,500');

SELECT * FROM Room_reservation WHERE hotel_name = 'Ocean Breeze Resort';