CREATE TABLE RESERVATION (
  ID INTEGER PRIMARY KEY,
  NAME TEXT NOT NULL,
  CONTACT TEXT NOT NULL,
  EMAIL TEXT NOT NULL,
  ROOM_TYPE TEXT NOT NULL,
  CHECK_IN_DATE DATE NOT NULL,
  CHECK_OUT_DATE DATE NOT NULL,
  PRICE INTEGER NOT NULL,
  STATUS TEXT NOT NULL
);

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (1, 'John Doe', '09111000000', 'john.doe@example.com', 'Single', '2024-03-01', '2024-03-03', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (2, 'Jane Smith', '09111000001', 'jane.smith@example.com', 'Double', '2024-03-05', '2024-03-10', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (3, 'Alice Johnson', '09111000002', 'alice.j@example.com', 'Suite', '2024-04-01', '2024-04-05', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (4, 'Bob Brown', '09111000003', 'bob.b@example.com', 'Single', '2024-04-10', '2024-04-12', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (5, 'Charlie Davis', '09111000004', 'charlie.d@example.com', 'Deluxe', '2024-05-15', '2024-05-20', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (6, 'Diana Evans', '09111000005', 'diana.e@example.com', 'Double', '2024-05-22', '2024-05-24', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (7, 'Ethan Ford', '09111000006', 'ethan.f@example.com', 'Suite', '2024-06-01', '2024-06-03', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (8, 'Fiona Green', '09111000007', 'fiona.g@example.com', 'Single', '2024-06-05', '2024-06-07', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (9, 'George Harris', '09111000008', 'george.h@example.com', 'Double', '2024-07-10', '2024-07-15', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (10, 'Hannah Irvine', '09111000009', 'hannah.i@example.com', 'Deluxe', '2024-07-20', '2024-07-25', 5000, 'Confirmed');

-- Continuing the pattern with varying details for each reservation:

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (11, 'Ian Jenkins', '09111000010', 'ian.j@example.com', 'Suite', '2024-08-01', '2024-08-05', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (12, 'Julia Kite', '09111000011', 'julia.k@example.com', 'Single', '2024-08-10', '2024-08-12', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (13, 'Kevin Lyle', '09111000012', 'kevin.l@example.com', 'Double', '2024-09-15', '2024-09-20', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (14, 'Linda Morse', '09111000013', 'linda.m@example.com', 'Deluxe', '2024-09-22', '2024-09-27', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (15, 'Mike Norton', '09111000014', 'mike.n@example.com', 'Suite', '2024-10-01', '2024-10-03', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (16, 'Nina Owens', '09111000015', 'nina.o@example.com', 'Single', '2024-10-05', '2024-10-07', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (17, 'Oliver Page', '09111000016', 'oliver.p@example.com', 'Double', '2024-11-10', '2024-11-12', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (18, 'Pamela Quinn', '09111000017', 'pamela.q@example.com', 'Deluxe', '2024-11-15', '2024-11-20', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (19, 'Quincy Rivers', '09111000018', 'quincy.r@example.com', 'Suite', '2024-12-01', '2024-12-05', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (20, 'Rachel Stone', '09111000019', 'rachel.s@example.com', 'Single', '2024-12-10', '2024-12-12', 1500, 'Confirmed');

-- And so on, adjusting the ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, and STATUS fields as needed to create unique reservations:

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (21, 'Steve Thomas', '09111000020', 'steve.t@example.com', 'Double', '2025-01-05', '2025-01-07', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (22, 'Tina Underwood', '09111000021', 'tina.u@example.com', 'Deluxe', '2025-01-10', '2025-01-15', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (23, 'Ulysses Vance', '09111000022', 'ulysses.v@example.com', 'Suite', '2025-02-01', '2025-02-03', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (24, 'Victoria Wells', '09111000023', 'victoria.w@example.com', 'Single', '2025-02-05', '2025-02-07', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (25, 'Walter Xander', '09111000024', 'walter.x@example.com', 'Double', '2025-03-10', '2025-03-12', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (26, 'Xenia York', '09111000025', 'xenia.y@example.com', 'Deluxe', '2025-03-15', '2025-03-20', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (27, 'Yvonne Zane', '09111000026', 'yvonne.z@example.com', 'Suite', '2025-04-01', '2025-04-03', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (28, 'Zachary Adams', '09111000027', 'zachary.a@example.com', 'Single', '2025-04-10', '2025-04-12', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (29, 'Amelia Bell', '09111000028', 'amelia.b@example.com', 'Double', '2025-05-05', '2025-05-07', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (30, 'Brian Carter', '09111000029', 'brian.c@example.com', 'Deluxe', '2025-05-10', '2025-05-15', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (31, 'Cynthia Dean', '09111000030', 'cynthia.d@example.com', 'Suite', '2025-06-01', '2025-06-03', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (32, 'Derek Evans', '09111000031', 'derek.e@example.com', 'Single', '2025-06-05', '2025-06-07', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (33, 'Erika Foster', '09111000032', 'erika.f@example.com', 'Double', '2025-07-10', '2025-07-12', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (34, 'Franklin Grant', '09111000033', 'franklin.g@example.com', 'Deluxe', '2025-07-15', '2025-07-20', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (35, 'Gloria Hanks', '09111000034', 'gloria.h@example.com', 'Suite', '2025-08-01', '2025-08-05', 4500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (36, 'Hector Irvine', '09111000035', 'hector.i@example.com', 'Single', '2025-08-10', '2025-08-12', 1500, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (37, 'Iris Jensen', '09111000036', 'iris.j@example.com', 'Double', '2025-09-05', '2025-09-07', 3000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (38, 'Jason Kidd', '09111000037', 'jason.k@example.com', 'Deluxe', '2025-09-10', '2025-09-15', 5000, 'Confirmed');

INSERT INTO RESERVATION (ID, NAME, CONTACT, EMAIL, ROOM_TYPE, CHECK_IN_DATE, CHECK_OUT_DATE, PRICE, STATUS)
VALUES (39, 'Kara Lloyd', '09111000038', 'kara.l@example.com', 'Suite', '2025-10-


ALTER TABLE RESERVATION
ADD Notes TEXT NOT NULL;

DELETE FROM RESERVATION WHERE Id IN (2, 4, 6, 8, 10);

UPDATE RESERVATION
SET S_Time = '1:00PM', E_Time = '3:00PM'
WHERE Id = 5;

SELECT * FROM RESERVATION;