CREATE TABLE Room_reservation (
  
  Reservation_ID INTEGER PRIMARY KEY ,
  Guest_ID INTEGER ,
  First_Name TEXT  ,
  Last_Name TEXT  ,
  Check_in_Date TEXT NOT NULL ,
  Check_out_Date TEXT NOT NULL ,
  Room_Number INTEGER ,
  Room_Type TEXT ,
  Hotel_ID INTEGER , 
  Hotel_Name TEXT ,
  Total_Payment TEXT
);

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

UPDATE Room_reservation
SET Check_out_Date = '2023-10-07', Room_Type = 'Superior'
WHERE Reservation_ID = 302;


SELECT * FROM Room_reservation ;