allSQL_code.sql

--***************************************************************************************
--Setup
--***************************************************************************************

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

CREATE TABLE Hotel_Chain (
	Hotel_Chain_ID SERIAL,
	hotel_chain_name VARCHAR(20) NOT NULL,
	Central_Office VARCHAR(50) NOT NULL,
	Number_Of_Hotels INTEGER DEFAULT 0,
	Contact_Email VARCHAR(50) NOT NULL,

	PRIMARY KEY (Hotel_Chain_ID)
);

CREATE TABLE HotelChain_PhoneNumbers (
	Hotel_Chain_ID INTEGER,
	Phone_Number NUMERIC(10),

	PRIMARY KEY (Hotel_Chain_ID, Phone_Number),
	FOREIGN KEY (Hotel_Chain_ID) REFERENCES hotel_chain (Hotel_Chain_ID) ON DELETE CASCADE
);

CREATE TABLE Hotel (
	Hotel_Chain_ID INTEGER NOT NULL,
	Hotel_ID SERIAL,
	Hotel_name VARCHAR(50) NOT NULL,
	Hotel_City VARCHAR(50) NOT NULL,
	Hotel_Contact_Email VARCHAR(50) NOT NULL,
	Number_Of_Rooms INTEGER DEFAULT 0 NOT NULL,
	Rating INTEGER CHECK (Rating BETWEEN 1 AND 5),
	manager_ssn NUMERIC(9),

	PRIMARY KEY (Hotel_ID),
	FOREIGN KEY (Hotel_Chain_ID) REFERENCES Hotel_Chain(Hotel_Chain_ID) ON DELETE CASCADE
);

CREATE TABLE Hotel_PhoneNumbers (
	Hotel_ID INTEGER,
	Phone_Number NUMERIC(10),

	PRIMARY KEY (Hotel_ID, Phone_Number),
	FOREIGN KEY (Hotel_ID) REFERENCES hotel(Hotel_ID) ON DELETE CASCADE
);

CREATE TABLE Room (
	Hotel_ID INTEGER,
	Room_Number INTEGER,
	Can_Be_Extended BOOLEAN NOT NULL,
	Has_Sea_View BOOLEAN NOT NULL,
	Has_Mountain_View BOOLEAN NOT NULL,
	Room_Capacity INTEGER NOT NULL,
	Price INTEGER NOT NULL,

	PRIMARY KEY (Hotel_ID, Room_Number),
	FOREIGN KEY (Hotel_ID) REFERENCES Hotel(Hotel_ID) ON DELETE CASCADE
);

CREATE TABLE Room_Amenities (
	hotel_id INTEGER,
	Room_Number INTEGER,
	Amenity VARCHAR(100),

	PRIMARY KEY (Hotel_ID, Room_Number, Amenity),
	FOREIGN KEY (hotel_id) REFERENCES Hotel(Hotel_ID) ON DELETE CASCADE,
	FOREIGN KEY (hotel_id, Room_Number) REFERENCES Room(hotel_id, Room_Number) ON DELETE CASCADE
);

CREATE TABLE Room_List_of_Problems (
	hotel_id INTEGER,
	Room_Number INTEGER,
	Problem VARCHAR(100),

	PRIMARY KEY (Hotel_ID, Room_Number, Problem),
	FOREIGN KEY (Hotel_ID) REFERENCES Hotel(Hotel_ID) ON DELETE CASCADE,
	FOREIGN KEY (hotel_id, Room_Number) REFERENCES Room(hotel_id, Room_Number) ON DELETE CASCADE
);

CREATE TABLE users (
	username VARCHAR(20),
	password VARCHAR(20) NOT NULL,
	type VARCHAR(10) DEFAULT 'user' CHECK (type IN ('user', 'employee', 'admin')),
	PRIMARY KEY (username)
);

CREATE TABLE Booking (
	Booking_ID SERIAL,
	Time_Created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	check_in_date DATE NOT NULL,
	check_out_date DATE NOT NULL,
	Is_Renting BOOLEAN DEFAULT false,
	username VARCHAR(20),
	Is_Paid BOOLEAN DEFAULT false,
	Hotel_ID INTEGER NOT NULL,
	Room_Number INTEGER NOT NULL,

	FOREIGN KEY (username) REFERENCES users(username) ON UPDATE CASCADE ON DELETE CASCADE,
	FOREIGN KEY (Hotel_ID) REFERENCES Hotel(Hotel_ID) ON DELETE CASCADE,
	FOREIGN KEY (hotel_id, Room_Number) REFERENCES Room(hotel_id, Room_Number) ON DELETE CASCADE,
	PRIMARY KEY (Booking_ID)
);

CREATE TABLE Employee (
	SSN NUMERIC(9) NOT NULL,
	Name VARCHAR(20) NOT NULL,
	username VARCHAR(20),
	Hotel_ID INTEGER NOT NULL,

	FOREIGN KEY (Hotel_ID) REFERENCES Hotel(Hotel_ID) ON DELETE SET NULL, --supposing we don't fire them if the hotel closes
	FOREIGN KEY (username) REFERENCES users(username) ON UPDATE CASCADE ON DELETE CASCADE,
	PRIMARY KEY (SSN)
);
ALTER TABLE hotel ADD CONSTRAINT manages_a FOREIGN KEY (manager_ssn) REFERENCES employee(ssn) ON DELETE SET NULL;


CREATE TABLE Archive (
	Booking_ID INTEGER,
	Time_Created TIME,
	check_in_date DATE,
	check_out_date DATE,
	Is_Renting BOOLEAN,
	username VARCHAR(20),
	Is_Paid BOOLEAN,
	Room_Number INTEGER,
	Hotel_ID INTEGER,

	PRIMARY KEY (Booking_ID)
);

CREATE VIEW rooms_by_area AS SELECT hotel_city, count(*) FROM hotel JOIN room ON hotel.hotel_id = room.hotel_id GROUP BY hotel_city;
CREATE VIEW hotel_room_capacity AS SELECT room_number, room_capacity FROM room WHERE hotel_id = 40;

GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO web;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO postgres;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO web;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO postgres;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO web;

--***************************************************************************************
--Triggers
--***************************************************************************************

CREATE OR REPLACE FUNCTION increment_hotel_count() RETURNS trigger AS
$body$
BEGIN
	UPDATE hotel_chain SET number_of_hotels = number_of_hotels + 1
		WHERE hotel_chain_id = NEW.hotel_chain_id;
	RETURN NEW;
END;
$body$
language plpgsql;

CREATE OR REPLACE FUNCTION decrement_hotel_count() RETURNS trigger AS
$body$
BEGIN
	UPDATE hotel_chain SET number_of_hotels = number_of_hotels - 1
		WHERE hotel_chain_id = OLD.hotel_chain_id;
	RETURN NEW;
END;
$body$
language plpgsql;

CREATE OR REPLACE FUNCTION increment_room_count() RETURNS trigger AS
$body$
BEGIN
	UPDATE hotel SET number_of_rooms = number_of_rooms + 1
		WHERE hotel_id = NEW.hotel_id;
	RETURN NEW;
END;
$body$
language plpgsql;

CREATE OR REPLACE FUNCTION decrement_room_count() RETURNS trigger AS
$body$
BEGIN
	UPDATE hotel SET number_of_rooms = number_of_rooms - 1
		WHERE hotel_id = OLD.hotel_id;
	RETURN NEW;
END;
$body$
language plpgsql;

CREATE TRIGGER add_hotel AFTER INSERT ON hotel
	FOR EACH ROW EXECUTE PROCEDURE increment_hotel_count();

CREATE TRIGGER del_hotel AFTER DELETE ON hotel
	FOR EACH ROW EXECUTE PROCEDURE decrement_hotel_count();

CREATE TRIGGER add_room AFTER INSERT ON room
	FOR EACH ROW EXECUTE PROCEDURE increment_room_count();

CREATE TRIGGER del_room AFTER DELETE ON room
	FOR EACH ROW EXECUTE PROCEDURE decrement_room_count();


CREATE OR REPLACE FUNCTION insert_archive() RETURNS trigger AS
$body$
BEGIN
	INSERT INTO archive (Booking_ID, Time_Created, check_in_date, check_out_date, Is_Renting, username, Is_Paid, Room_Number, Hotel_ID) VALUES (NEW.Booking_ID, NEW.Time_Created, NEW.check_in_date, NEW.check_out_date, NEW.Is_Renting, NEW.username, NEW.Is_Paid, NEW.Room_Number, NEW.Hotel_ID);
	RETURN NEW;
END;
$body$
language plpgsql;

CREATE OR REPLACE FUNCTION update_archive() RETURNS trigger AS
$body$
BEGIN
	UPDATE archive SET Time_Created = NEW.Time_Created, check_in_date = NEW.check_in_date, check_out_date = NEW.check_out_date, Is_Renting = NEW.Is_Renting, username = NEW.username, Is_Paid = NEW.Is_Paid, Room_Number = NEW.Room_Number, Hotel_ID = NEW.Hotel_ID WHERE Booking_ID = NEW.Booking_ID;
	RETURN NEW;
END;
$body$
language plpgsql;



CREATE TRIGGER add_archive AFTER INSERT ON booking
	FOR EACH ROW EXECUTE PROCEDURE insert_archive();

CREATE TRIGGER update_archive AFTER UPDATE ON booking
	FOR EACH ROW EXECUTE PROCEDURE update_archive();

--***************************************************************************************
-- Mock Data
--***************************************************************************************

INSERT INTO hotel_chain (hotel_chain_name, central_office, contact_email) VALUES ('Hilton', 'Washington', 'Hilton@Hilton.com');
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Ottawa', 'Ottawa', 'Ottawa@Hilton.com', 1);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 100, True, True, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 101, False, False, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 102, False, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 103, True, False, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 104, True, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 105, True, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 106, True, True, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 107, False, False, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 108, False, False, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 109, True, False, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 200, False, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 201, False, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 202, False, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 203, True, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 204, False, False, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 205, True, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 206, False, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 207, False, True, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 208, True, False, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 209, False, True, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 300, False, False, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 301, False, True, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 302, False, False, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 303, False, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 304, True, False, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 305, False, False, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 306, True, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 307, False, False, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 308, True, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 309, True, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 400, False, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 401, True, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 402, True, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 403, False, True, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 404, False, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 405, True, False, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 406, False, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 407, True, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 408, True, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (1, 409, True, True, True, 6, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Toronto', 'Toronto', 'Toronto@Hilton.com', 1);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 100, False, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 101, True, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 102, True, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 103, False, False, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 104, True, False, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 105, False, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 106, False, False, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 107, True, False, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 108, True, True, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 109, True, True, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 200, True, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 201, True, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 202, True, False, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 203, True, False, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 204, False, False, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 205, False, True, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 206, False, False, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 207, False, False, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 208, True, False, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 209, True, True, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 300, True, True, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 301, False, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 302, True, True, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 303, True, False, True, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 304, False, False, True, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 305, False, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 306, False, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 307, False, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 308, True, True, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 309, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 400, False, True, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 401, False, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 402, False, False, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 403, False, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 404, True, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 405, True, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 406, False, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 407, False, True, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 408, True, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (2, 409, False, True, False, 7, 110);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton NYC', 'NYC', 'NYC@Hilton.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 100, True, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 101, False, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 102, True, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 103, False, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 104, False, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 105, False, False, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 106, True, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 107, False, True, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 108, True, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 109, True, False, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 200, False, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 201, False, False, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 202, True, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 203, False, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 204, True, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 205, False, False, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 206, True, True, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 207, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 208, False, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 209, False, False, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 300, True, False, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 301, False, False, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 302, True, False, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 303, False, True, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 304, True, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 305, False, False, True, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 306, False, True, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 307, True, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 308, False, True, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 309, True, False, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 400, False, False, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 401, False, True, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 402, False, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 403, True, False, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 404, True, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 405, False, False, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 406, False, False, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 407, False, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 408, True, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (3, 409, True, True, True, 7, 160);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Syracuse', 'Syracuse', 'Syracuse@Hilton.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 100, False, False, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 101, False, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 102, False, False, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 103, False, True, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 104, False, False, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 105, True, False, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 106, True, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 107, False, False, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 108, False, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 109, False, True, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 200, True, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 201, False, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 202, False, False, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 203, True, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 204, False, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 205, False, True, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 206, False, True, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 207, True, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 208, True, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 209, True, False, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 300, True, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 301, True, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 302, True, True, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 303, True, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 304, False, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 305, False, True, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 306, True, False, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 307, False, True, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 308, True, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 309, True, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 400, False, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 401, False, True, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 402, False, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 403, True, False, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 404, True, False, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 405, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 406, True, True, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 407, True, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 408, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (4, 409, True, False, False, 3, 130);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Montreal', 'Montreal', 'Montreal@Hilton.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 100, True, True, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 101, True, False, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 102, False, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 103, True, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 104, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 105, True, True, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 106, True, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 107, True, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 108, True, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 109, True, False, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 200, True, True, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 201, False, True, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 202, False, True, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 203, False, True, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 204, False, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 205, True, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 206, True, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 207, True, True, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 208, False, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 209, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 300, True, False, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 301, False, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 302, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 303, True, True, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 304, True, True, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 305, False, False, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 306, False, True, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 307, False, True, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 308, False, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 309, False, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 400, False, False, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 401, True, False, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 402, True, True, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 403, False, False, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 404, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 405, False, False, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 406, True, True, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 407, True, False, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 408, False, False, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (5, 409, True, True, True, 4, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Detroit', 'Detroit', 'Detroit@Hilton.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 100, False, False, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 101, False, False, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 102, True, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 103, False, False, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 104, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 105, True, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 106, True, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 107, True, False, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 108, True, True, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 109, True, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 200, True, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 201, True, False, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 202, False, True, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 203, True, True, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 204, False, True, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 205, True, True, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 206, True, False, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 207, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 208, False, False, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 209, True, True, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 300, True, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 301, True, False, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 302, True, True, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 303, True, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 304, False, True, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 305, True, True, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 306, True, False, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 307, False, False, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 308, False, False, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 309, True, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 400, False, True, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 401, True, False, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 402, False, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 403, True, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 404, True, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 405, True, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 406, True, True, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 407, False, True, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 408, True, False, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (6, 409, False, False, False, 4, 160);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Los Angeles1', 'Los Angeles', 'Los_Angeles1@Hilton.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 100, True, True, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 101, True, True, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 102, True, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 103, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 104, False, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 105, False, False, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 106, True, True, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 107, False, True, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 108, False, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 109, True, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 200, False, False, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 201, False, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 202, False, False, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 203, False, True, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 204, True, False, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 205, False, True, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 206, True, False, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 207, False, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 208, True, False, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 209, True, True, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 300, True, True, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 301, False, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 302, False, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 303, True, True, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 304, True, False, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 305, True, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 306, False, True, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 307, False, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 308, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 309, False, True, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 400, False, False, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 401, False, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 402, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 403, True, True, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 404, False, True, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 405, True, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 406, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 407, True, True, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 408, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (7, 409, True, True, True, 4, 200);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (1, 'Hilton Los Angeles2', 'Los Angeles', 'Los_Angeles2@Hilton.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 100, False, False, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 101, False, True, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 102, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 103, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 104, False, True, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 105, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 106, True, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 107, False, False, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 108, True, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 109, True, False, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 200, False, True, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 201, False, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 202, False, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 203, True, False, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 204, True, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 205, False, True, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 206, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 207, True, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 208, False, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 209, True, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 300, True, True, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 301, True, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 302, False, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 303, False, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 304, False, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 305, False, False, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 306, True, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 307, False, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 308, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 309, False, False, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 400, False, False, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 401, False, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 402, False, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 403, False, True, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 404, True, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 405, False, False, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 406, False, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 407, False, True, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 408, False, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (8, 409, False, True, True, 4, 190);
INSERT INTO hotel_chain (hotel_chain_name, central_office, contact_email) VALUES ('Holiday Inn', 'Washington', 'Holiday_Inn@Holiday_Inn.com');
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Ottawa', 'Ottawa', 'Ottawa@Holiday_Inn.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 100, True, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 101, True, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 102, False, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 103, False, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 104, True, False, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 105, True, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 106, False, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 107, True, False, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 108, False, True, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 109, True, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 200, False, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 201, True, False, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 202, True, False, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 203, True, True, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 204, True, True, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 205, False, False, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 206, False, True, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 207, True, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 208, False, True, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 209, False, True, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 300, True, False, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 301, False, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 302, True, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 303, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 304, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 305, True, False, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 306, True, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 307, True, False, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 308, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 309, False, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 400, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 401, False, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 402, True, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 403, True, False, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 404, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 405, True, False, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 406, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 407, True, False, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 408, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (9, 409, False, True, True, 7, 130);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Toronto', 'Toronto', 'Toronto@Holiday_Inn.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 100, False, False, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 101, True, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 102, False, False, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 103, False, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 104, True, False, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 105, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 106, True, True, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 107, True, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 108, False, True, True, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 109, True, False, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 200, False, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 201, False, True, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 202, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 203, False, True, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 204, True, False, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 205, False, True, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 206, True, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 207, True, False, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 208, False, False, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 209, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 300, True, True, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 301, False, True, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 302, True, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 303, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 304, True, False, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 305, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 306, False, False, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 307, True, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 308, True, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 309, False, False, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 400, False, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 401, False, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 402, True, False, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 403, False, False, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 404, True, False, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 405, True, False, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 406, True, True, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 407, False, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 408, True, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (10, 409, True, True, False, 6, 100);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn NYC', 'NYC', 'NYC@Holiday_Inn.com', 1);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 100, True, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 101, False, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 102, True, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 103, False, False, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 104, False, False, True, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 105, True, False, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 106, False, True, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 107, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 108, False, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 109, False, False, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 200, False, True, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 201, False, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 202, True, False, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 203, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 204, True, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 205, True, True, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 206, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 207, True, False, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 208, False, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 209, True, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 300, False, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 301, True, False, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 302, False, False, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 303, False, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 304, False, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 305, True, True, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 306, False, False, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 307, False, True, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 308, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 309, False, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 400, True, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 401, False, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 402, False, False, True, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 403, True, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 404, False, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 405, False, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 406, True, True, True, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 407, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 408, True, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (11, 409, False, True, True, 7, 190);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Syracuse', 'Syracuse', 'Syracuse@Holiday_Inn.com', 1);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 100, True, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 101, False, True, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 102, False, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 103, False, True, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 104, False, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 105, False, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 106, False, False, True, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 107, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 108, True, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 109, False, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 200, True, True, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 201, True, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 202, True, True, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 203, False, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 204, True, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 205, False, False, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 206, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 207, True, True, True, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 208, False, False, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 209, False, False, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 300, False, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 301, True, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 302, False, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 303, False, True, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 304, False, False, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 305, True, False, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 306, True, False, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 307, True, True, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 308, False, True, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 309, True, True, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 400, True, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 401, True, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 402, True, False, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 403, True, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 404, False, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 405, False, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 406, True, True, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 407, True, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 408, True, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (12, 409, False, False, True, 3, 120);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Montreal', 'Montreal', 'Montreal@Holiday_Inn.com', 3);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 100, True, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 101, True, False, True, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 102, True, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 103, True, False, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 104, False, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 105, True, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 106, True, False, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 107, True, True, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 108, False, True, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 109, False, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 200, False, True, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 201, True, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 202, True, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 203, False, False, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 204, False, False, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 205, True, True, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 206, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 207, True, False, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 208, False, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 209, True, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 300, False, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 301, False, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 302, False, True, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 303, True, False, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 304, True, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 305, False, True, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 306, True, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 307, False, False, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 308, False, True, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 309, False, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 400, False, True, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 401, False, False, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 402, False, True, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 403, False, False, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 404, True, False, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 405, False, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 406, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 407, False, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 408, False, True, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (13, 409, False, True, True, 5, 100);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Detroit', 'Detroit', 'Detroit@Holiday_Inn.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 100, False, False, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 101, True, False, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 102, False, True, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 103, True, False, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 104, True, False, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 105, False, False, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 106, True, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 107, True, False, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 108, False, False, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 109, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 200, True, False, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 201, False, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 202, True, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 203, True, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 204, True, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 205, False, False, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 206, False, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 207, True, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 208, False, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 209, True, True, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 300, True, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 301, False, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 302, True, True, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 303, False, False, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 304, False, False, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 305, False, False, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 306, True, False, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 307, True, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 308, False, False, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 309, True, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 400, True, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 401, False, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 402, True, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 403, False, False, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 404, False, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 405, False, False, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 406, False, False, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 407, True, True, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 408, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (14, 409, False, True, True, 5, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Los Angeles1', 'Los Angeles', 'Los_Angeles1@Holiday_Inn.com', 3);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 100, False, True, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 101, True, False, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 102, True, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 103, False, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 104, True, True, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 105, False, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 106, True, True, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 107, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 108, True, False, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 109, True, False, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 200, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 201, True, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 202, True, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 203, False, True, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 204, False, True, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 205, True, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 206, False, False, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 207, False, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 208, False, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 209, False, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 300, False, False, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 301, False, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 302, False, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 303, False, False, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 304, False, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 305, True, True, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 306, True, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 307, True, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 308, False, False, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 309, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 400, False, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 401, False, True, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 402, False, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 403, True, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 404, False, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 405, True, True, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 406, True, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 407, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 408, True, False, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (15, 409, False, True, False, 4, 180);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (2, 'Holiday Inn Los Angeles2', 'Los Angeles', 'Los_Angeles2@Holiday_Inn.com', 3);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 100, False, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 101, True, False, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 102, False, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 103, False, False, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 104, False, False, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 105, False, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 106, True, False, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 107, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 108, False, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 109, False, False, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 200, True, True, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 201, False, False, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 202, True, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 203, False, True, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 204, True, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 205, False, False, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 206, False, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 207, True, False, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 208, True, False, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 209, True, False, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 300, True, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 301, False, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 302, True, False, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 303, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 304, False, False, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 305, True, True, True, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 306, False, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 307, True, False, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 308, False, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 309, True, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 400, False, True, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 401, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 402, True, False, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 403, False, True, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 404, False, True, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 405, True, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 406, False, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 407, False, False, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 408, True, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (16, 409, False, False, True, 2, 180);
INSERT INTO hotel_chain (hotel_chain_name, central_office, contact_email) VALUES ('Marriot', 'Washington', 'Marriot@Marriot.com');
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Ottawa', 'Ottawa', 'Ottawa@Marriot.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 100, False, True, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 101, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 102, False, True, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 103, False, False, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 104, False, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 105, False, False, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 106, False, True, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 107, True, False, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 108, False, True, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 109, True, False, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 200, False, False, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 201, False, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 202, True, False, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 203, False, False, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 204, False, False, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 205, False, False, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 206, False, True, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 207, True, False, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 208, False, True, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 209, False, False, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 300, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 301, False, True, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 302, False, False, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 303, False, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 304, True, False, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 305, True, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 306, False, False, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 307, True, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 308, False, False, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 309, False, False, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 400, True, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 401, False, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 402, False, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 403, True, True, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 404, True, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 405, False, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 406, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 407, False, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 408, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (17, 409, False, False, False, 2, 200);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Toronto', 'Toronto', 'Toronto@Marriot.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 100, True, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 101, True, False, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 102, False, False, True, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 103, True, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 104, False, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 105, True, False, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 106, True, True, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 107, False, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 108, False, True, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 109, True, False, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 200, False, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 201, False, False, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 202, False, False, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 203, True, True, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 204, True, True, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 205, False, False, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 206, True, True, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 207, True, True, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 208, False, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 209, False, False, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 300, True, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 301, True, True, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 302, False, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 303, True, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 304, True, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 305, False, False, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 306, False, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 307, False, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 308, True, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 309, False, False, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 400, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 401, False, True, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 402, True, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 403, False, True, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 404, True, True, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 405, True, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 406, False, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 407, True, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 408, True, True, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (18, 409, False, False, False, 2, 200);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot NYC', 'NYC', 'NYC@Marriot.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 100, False, False, False, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 101, False, False, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 102, False, False, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 103, False, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 104, False, True, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 105, False, False, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 106, False, False, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 107, True, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 108, True, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 109, False, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 200, False, False, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 201, True, False, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 202, True, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 203, True, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 204, True, True, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 205, False, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 206, False, False, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 207, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 208, True, False, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 209, False, False, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 300, False, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 301, False, True, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 302, True, False, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 303, False, False, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 304, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 305, True, False, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 306, True, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 307, True, False, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 308, False, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 309, True, False, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 400, False, False, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 401, False, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 402, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 403, False, True, False, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 404, False, False, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 405, False, True, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 406, False, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 407, False, False, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 408, True, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (19, 409, False, False, True, 7, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Syracuse', 'Syracuse', 'Syracuse@Marriot.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 100, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 101, False, False, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 102, True, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 103, True, True, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 104, True, False, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 105, False, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 106, True, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 107, False, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 108, False, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 109, True, False, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 200, True, True, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 201, True, True, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 202, False, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 203, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 204, False, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 205, False, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 206, False, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 207, False, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 208, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 209, False, True, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 300, True, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 301, True, True, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 302, True, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 303, True, True, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 304, False, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 305, False, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 306, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 307, False, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 308, False, False, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 309, False, False, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 400, True, True, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 401, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 402, False, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 403, False, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 404, True, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 405, False, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 406, False, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 407, True, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 408, False, False, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (20, 409, True, False, False, 3, 190);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Montreal', 'Montreal', 'Montreal@Marriot.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 100, False, False, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 101, True, False, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 102, False, True, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 103, False, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 104, False, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 105, True, True, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 106, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 107, False, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 108, True, True, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 109, False, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 200, True, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 201, True, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 202, False, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 203, False, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 204, False, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 205, False, False, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 206, True, True, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 207, True, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 208, False, True, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 209, False, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 300, False, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 301, True, False, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 302, False, False, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 303, True, True, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 304, True, False, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 305, False, False, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 306, False, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 307, False, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 308, True, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 309, False, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 400, False, True, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 401, True, False, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 402, True, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 403, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 404, True, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 405, False, True, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 406, True, False, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 407, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 408, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (21, 409, True, True, False, 4, 200);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Detroit', 'Detroit', 'Detroit@Marriot.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 100, False, False, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 101, True, False, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 102, False, True, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 103, True, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 104, True, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 105, False, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 106, True, True, True, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 107, False, False, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 108, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 109, True, False, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 200, False, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 201, True, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 202, True, True, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 203, False, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 204, False, False, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 205, False, True, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 206, False, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 207, False, False, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 208, True, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 209, True, False, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 300, True, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 301, False, True, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 302, True, False, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 303, False, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 304, False, False, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 305, True, False, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 306, True, False, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 307, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 308, True, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 309, False, True, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 400, False, False, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 401, False, True, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 402, True, False, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 403, True, True, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 404, True, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 405, True, False, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 406, True, False, True, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 407, False, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 408, False, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (22, 409, False, True, False, 2, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Los Angeles1', 'Los Angeles', 'Los_Angeles1@Marriot.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 100, True, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 101, True, True, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 102, False, False, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 103, True, True, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 104, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 105, False, True, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 106, False, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 107, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 108, False, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 109, False, False, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 200, False, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 201, True, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 202, True, False, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 203, True, True, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 204, False, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 205, True, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 206, True, True, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 207, True, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 208, False, True, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 209, True, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 300, False, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 301, True, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 302, True, True, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 303, False, True, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 304, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 305, True, False, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 306, False, False, True, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 307, True, True, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 308, False, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 309, False, False, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 400, False, False, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 401, False, False, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 402, False, False, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 403, False, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 404, False, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 405, False, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 406, True, True, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 407, True, True, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 408, True, True, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (23, 409, False, False, False, 6, 150);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (3, 'Marriot Los Angeles2', 'Los Angeles', 'Los_Angeles2@Marriot.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 100, False, False, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 101, True, True, True, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 102, True, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 103, False, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 104, True, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 105, True, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 106, True, False, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 107, True, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 108, False, False, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 109, False, False, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 200, True, False, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 201, True, True, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 202, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 203, False, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 204, True, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 205, True, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 206, True, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 207, True, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 208, False, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 209, False, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 300, True, True, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 301, True, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 302, True, False, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 303, False, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 304, False, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 305, False, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 306, True, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 307, True, False, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 308, True, False, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 309, False, True, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 400, True, True, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 401, True, False, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 402, False, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 403, True, False, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 404, False, True, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 405, True, False, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 406, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 407, True, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 408, True, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (24, 409, True, True, True, 2, 180);
INSERT INTO hotel_chain (hotel_chain_name, central_office, contact_email) VALUES ('Best Western', 'Washington', 'Best_Western@Best_Western.com');
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Ottawa', 'Ottawa', 'Ottawa@Best_Western.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 100, True, False, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 101, False, True, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 102, True, True, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 103, True, False, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 104, True, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 105, True, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 106, False, False, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 107, True, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 108, False, False, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 109, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 200, False, False, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 201, False, False, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 202, False, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 203, True, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 204, False, True, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 205, True, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 206, False, False, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 207, False, True, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 208, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 209, False, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 300, True, True, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 301, True, True, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 302, False, True, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 303, False, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 304, True, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 305, True, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 306, False, True, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 307, True, False, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 308, True, False, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 309, True, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 400, True, False, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 401, True, False, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 402, False, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 403, True, False, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 404, True, False, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 405, True, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 406, False, False, False, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 407, False, False, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 408, False, False, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (25, 409, True, False, True, 5, 120);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Toronto', 'Toronto', 'Toronto@Best_Western.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 100, False, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 101, True, False, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 102, True, True, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 103, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 104, True, False, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 105, True, True, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 106, True, True, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 107, True, True, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 108, True, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 109, True, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 200, False, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 201, True, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 202, False, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 203, False, False, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 204, True, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 205, False, False, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 206, False, True, False, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 207, False, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 208, False, False, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 209, True, True, True, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 300, True, False, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 301, True, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 302, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 303, False, True, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 304, False, False, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 305, False, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 306, False, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 307, False, False, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 308, False, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 309, True, True, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 400, False, False, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 401, False, True, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 402, True, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 403, False, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 404, True, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 405, False, False, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 406, True, True, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 407, False, False, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 408, True, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (26, 409, False, True, False, 2, 130);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western NYC', 'NYC', 'NYC@Best_Western.com', 3);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 100, False, False, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 101, False, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 102, False, False, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 103, False, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 104, True, False, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 105, True, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 106, False, True, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 107, False, False, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 108, False, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 109, True, False, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 200, True, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 201, True, False, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 202, False, False, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 203, True, True, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 204, False, False, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 205, True, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 206, True, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 207, False, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 208, False, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 209, False, True, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 300, False, False, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 301, True, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 302, True, False, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 303, True, True, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 304, False, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 305, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 306, False, True, False, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 307, False, False, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 308, False, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 309, False, False, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 400, False, True, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 401, False, False, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 402, True, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 403, False, True, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 404, False, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 405, True, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 406, False, True, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 407, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 408, False, False, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (27, 409, True, False, False, 5, 200);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Syracuse', 'Syracuse', 'Syracuse@Best_Western.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 100, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 101, True, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 102, True, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 103, False, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 104, False, False, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 105, True, False, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 106, True, False, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 107, True, False, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 108, False, True, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 109, False, False, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 200, True, True, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 201, False, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 202, True, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 203, True, False, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 204, True, True, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 205, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 206, True, False, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 207, True, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 208, False, False, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 209, True, True, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 300, True, False, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 301, True, False, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 302, False, False, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 303, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 304, False, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 305, True, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 306, True, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 307, False, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 308, False, True, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 309, True, False, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 400, True, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 401, False, True, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 402, True, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 403, False, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 404, False, True, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 405, False, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 406, False, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 407, False, True, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 408, False, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (28, 409, False, True, False, 3, 120);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Montreal', 'Montreal', 'Montreal@Best_Western.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 100, False, True, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 101, False, True, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 102, False, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 103, False, False, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 104, True, False, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 105, False, False, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 106, False, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 107, True, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 108, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 109, False, False, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 200, False, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 201, True, True, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 202, False, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 203, True, False, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 204, False, True, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 205, True, False, False, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 206, False, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 207, True, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 208, False, True, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 209, True, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 300, True, True, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 301, True, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 302, False, False, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 303, True, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 304, False, True, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 305, True, False, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 306, False, False, False, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 307, True, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 308, False, True, False, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 309, False, False, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 400, False, True, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 401, False, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 402, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 403, False, False, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 404, True, False, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 405, True, True, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 406, False, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 407, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 408, True, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (29, 409, True, True, True, 7, 110);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Detroit', 'Detroit', 'Detroit@Best_Western.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 100, False, True, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 101, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 102, False, True, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 103, False, False, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 104, False, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 105, False, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 106, False, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 107, False, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 108, True, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 109, False, False, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 200, False, True, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 201, True, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 202, True, True, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 203, False, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 204, True, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 205, True, False, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 206, False, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 207, False, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 208, False, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 209, True, True, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 300, False, False, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 301, True, True, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 302, True, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 303, True, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 304, True, False, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 305, True, False, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 306, False, False, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 307, False, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 308, True, False, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 309, False, True, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 400, False, False, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 401, True, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 402, False, True, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 403, False, False, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 404, True, False, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 405, True, True, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 406, True, False, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 407, True, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 408, True, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (30, 409, False, True, True, 5, 190);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Los Angeles1', 'Los Angeles', 'Los_Angeles1@Best_Western.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 100, False, True, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 101, False, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 102, True, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 103, False, False, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 104, False, False, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 105, False, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 106, True, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 107, True, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 108, False, False, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 109, False, False, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 200, True, True, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 201, False, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 202, False, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 203, True, True, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 204, True, False, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 205, False, False, False, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 206, True, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 207, False, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 208, False, False, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 209, False, True, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 300, False, False, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 301, False, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 302, True, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 303, False, False, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 304, False, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 305, True, False, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 306, True, False, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 307, False, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 308, False, True, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 309, True, False, False, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 400, True, True, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 401, True, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 402, True, False, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 403, True, False, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 404, True, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 405, False, False, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 406, True, True, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 407, True, True, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 408, True, True, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (31, 409, False, False, True, 7, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (4, 'Best Western Los Angeles2', 'Los Angeles', 'Los_Angeles2@Best_Western.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 100, False, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 101, True, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 102, True, True, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 103, False, True, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 104, True, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 105, False, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 106, False, False, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 107, True, True, True, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 108, False, True, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 109, False, True, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 200, True, False, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 201, False, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 202, True, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 203, False, False, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 204, False, False, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 205, False, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 206, True, False, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 207, True, False, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 208, True, False, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 209, True, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 300, False, True, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 301, False, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 302, False, False, True, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 303, True, False, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 304, True, True, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 305, False, False, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 306, False, True, False, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 307, False, False, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 308, False, True, True, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 309, True, True, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 400, True, True, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 401, False, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 402, True, True, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 403, True, False, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 404, False, False, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 405, False, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 406, False, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 407, True, False, False, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 408, False, True, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (32, 409, False, False, True, 2, 110);
INSERT INTO hotel_chain (hotel_chain_name, central_office, contact_email) VALUES ('Wyndham', 'Washington', 'Wyndham@Wyndham.com');
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Ottawa', 'Ottawa', 'Ottawa@Wyndham.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 100, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 101, False, False, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 102, False, True, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 103, True, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 104, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 105, False, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 106, True, True, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 107, True, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 108, True, False, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 109, True, False, True, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 200, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 201, True, False, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 202, True, True, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 203, True, True, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 204, False, True, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 205, False, True, True, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 206, False, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 207, True, True, True, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 208, False, True, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 209, False, False, False, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 300, False, False, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 301, True, True, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 302, True, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 303, True, False, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 304, False, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 305, True, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 306, False, False, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 307, True, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 308, False, False, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 309, True, False, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 400, False, True, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 401, True, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 402, False, True, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 403, True, True, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 404, False, False, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 405, False, True, False, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 406, True, True, True, 7, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 407, True, True, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 408, True, False, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (33, 409, False, False, True, 3, 140);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Toronto', 'Toronto', 'Toronto@Wyndham.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 100, False, False, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 101, False, True, False, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 102, True, True, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 103, False, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 104, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 105, True, False, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 106, True, False, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 107, False, True, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 108, True, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 109, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 200, True, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 201, True, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 202, True, True, False, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 203, False, False, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 204, False, False, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 205, True, False, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 206, True, True, True, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 207, True, True, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 208, True, True, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 209, True, False, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 300, False, True, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 301, True, True, False, 5, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 302, False, False, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 303, True, False, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 304, False, False, False, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 305, False, False, False, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 306, True, False, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 307, False, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 308, False, False, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 309, False, False, True, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 400, False, True, False, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 401, False, True, True, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 402, False, False, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 403, True, True, True, 3, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 404, False, True, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 405, True, True, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 406, True, False, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 407, True, True, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 408, True, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (34, 409, False, True, True, 4, 110);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham NYC', 'NYC', 'NYC@Wyndham.com', 5);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 100, True, False, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 101, True, True, True, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 102, True, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 103, True, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 104, True, True, False, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 105, True, False, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 106, True, True, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 107, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 108, True, True, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 109, False, True, True, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 200, False, True, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 201, True, False, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 202, True, True, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 203, True, True, False, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 204, False, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 205, False, True, True, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 206, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 207, True, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 208, False, False, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 209, False, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 300, False, False, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 301, False, True, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 302, False, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 303, False, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 304, True, False, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 305, False, True, True, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 306, False, False, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 307, False, False, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 308, True, False, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 309, False, False, True, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 400, True, True, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 401, False, True, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 402, True, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 403, True, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 404, False, True, True, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 405, True, False, False, 2, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 406, True, True, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 407, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 408, False, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (35, 409, False, True, True, 2, 110);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Syracuse', 'Syracuse', 'Syracuse@Wyndham.com', 1);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 100, True, True, True, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 101, True, False, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 102, True, True, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 103, False, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 104, True, False, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 105, True, True, False, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 106, False, True, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 107, False, True, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 108, True, False, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 109, False, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 200, False, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 201, True, True, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 202, True, False, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 203, False, False, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 204, True, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 205, False, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 206, False, True, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 207, False, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 208, True, False, True, 2, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 209, False, False, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 300, False, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 301, True, False, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 302, False, False, True, 5, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 303, False, True, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 304, False, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 305, True, False, True, 2, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 306, True, False, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 307, True, True, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 308, False, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 309, False, True, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 400, False, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 401, True, False, True, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 402, False, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 403, False, True, True, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 404, True, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 405, True, True, True, 2, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 406, False, False, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 407, True, False, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 408, True, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (36, 409, False, True, False, 4, 150);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Montreal', 'Montreal', 'Montreal@Wyndham.com', 4);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 100, True, False, True, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 101, True, True, False, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 102, True, False, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 103, True, False, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 104, True, False, True, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 105, False, True, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 106, False, False, True, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 107, False, True, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 108, False, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 109, False, False, False, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 200, True, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 201, False, False, False, 4, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 202, False, True, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 203, True, False, True, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 204, False, True, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 205, True, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 206, True, True, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 207, True, True, True, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 208, True, False, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 209, True, False, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 300, False, True, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 301, True, False, False, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 302, True, False, True, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 303, True, False, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 304, True, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 305, True, False, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 306, True, True, True, 6, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 307, True, True, False, 5, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 308, False, False, False, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 309, False, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 400, False, True, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 401, False, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 402, True, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 403, True, False, True, 4, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 404, False, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 405, True, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 406, False, False, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 407, True, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 408, False, True, True, 6, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (37, 409, True, False, False, 4, 150);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Detroit', 'Detroit', 'Detroit@Wyndham.com', 2);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 100, True, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 101, False, False, False, 7, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 102, True, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 103, False, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 104, False, True, False, 7, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 105, True, False, False, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 106, False, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 107, True, True, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 108, True, False, False, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 109, False, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 200, False, True, False, 4, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 201, True, False, True, 4, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 202, False, True, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 203, True, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 204, False, False, False, 2, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 205, False, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 206, True, True, False, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 207, False, False, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 208, False, True, False, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 209, True, False, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 300, True, True, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 301, True, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 302, True, False, False, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 303, True, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 304, True, False, True, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 305, False, False, True, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 306, True, False, False, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 307, True, True, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 308, False, False, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 309, False, True, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 400, False, True, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 401, True, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 402, False, True, False, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 403, False, False, True, 6, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 404, False, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 405, False, True, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 406, True, True, False, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 407, False, False, False, 4, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 408, False, False, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (38, 409, True, False, True, 3, 110);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Los Angeles1', 'Los Angeles', 'Los_Angeles1@Wyndham.com', 3);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 100, True, True, True, 6, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 101, True, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 102, False, False, True, 3, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 103, True, True, False, 5, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 104, True, True, False, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 105, True, False, True, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 106, True, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 107, True, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 108, False, False, False, 6, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 109, True, False, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 200, False, True, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 201, False, False, True, 7, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 202, True, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 203, True, False, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 204, True, True, False, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 205, False, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 206, False, True, True, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 207, False, True, True, 4, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 208, False, False, False, 3, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 209, False, True, True, 4, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 300, False, False, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 301, True, True, True, 7, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 302, False, True, True, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 303, False, True, True, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 304, False, True, False, 2, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 305, False, True, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 306, False, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 307, True, True, False, 6, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 308, False, False, False, 3, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 309, False, True, False, 5, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 400, True, True, True, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 401, True, True, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 402, True, True, True, 2, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 403, True, True, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 404, False, False, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 405, False, False, True, 3, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 406, False, False, True, 4, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 407, False, True, False, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 408, True, False, True, 5, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (39, 409, False, True, True, 2, 100);
INSERT INTO hotel (hotel_chain_id, hotel_name, hotel_city, hotel_contact_email, rating) VALUES (5, 'Wyndham Los Angeles2', 'Los Angeles', 'Los_Angeles2@Wyndham.com', 3);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 100, True, False, False, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 101, False, False, False, 2, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 102, True, True, False, 6, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 103, True, False, True, 7, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 104, False, True, True, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 105, True, True, False, 6, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 106, True, True, False, 2, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 107, False, True, False, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 108, False, False, False, 4, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 109, False, False, False, 5, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 200, False, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 201, True, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 202, False, False, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 203, False, True, False, 5, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 204, True, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 205, True, True, True, 5, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 206, False, True, False, 4, 190);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 207, False, True, True, 4, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 208, False, False, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 209, False, True, True, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 300, True, False, True, 3, 150);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 301, True, False, True, 6, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 302, True, True, True, 7, 100);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 303, True, True, True, 3, 200);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 304, True, True, True, 5, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 305, False, False, False, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 306, True, True, False, 6, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 307, True, True, True, 3, 110);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 308, False, True, True, 3, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 309, False, True, True, 3, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 400, False, True, False, 2, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 401, False, False, False, 7, 140);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 402, True, True, False, 5, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 403, True, True, True, 7, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 404, True, True, False, 7, 130);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 405, False, False, False, 7, 120);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 406, False, True, True, 3, 170);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 407, True, True, True, 2, 160);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 408, False, True, False, 6, 180);
INSERT INTO room (hotel_id, room_number, can_be_extended, has_sea_view, has_mountain_view, room_capacity, price) VALUES (40, 409, False, True, True, 5, 170);
INSERT INTO users (username, password, type) VALUES ('Jim0', '0', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000000', 'Jim', 'Jim0', 1);
UPDATE hotel SET manager_ssn = '100000000' WHERE hotel_id = 1;
INSERT INTO users (username, password, type) VALUES ('Jim1', '1', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000001', 'Jim', 'Jim1', 2);
UPDATE hotel SET manager_ssn = '100000001' WHERE hotel_id = 2;
INSERT INTO users (username, password, type) VALUES ('Jim2', '2', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000002', 'Jim', 'Jim2', 3);
UPDATE hotel SET manager_ssn = '100000002' WHERE hotel_id = 3;
INSERT INTO users (username, password, type) VALUES ('Jim3', '3', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000003', 'Jim', 'Jim3', 4);
UPDATE hotel SET manager_ssn = '100000003' WHERE hotel_id = 4;
INSERT INTO users (username, password, type) VALUES ('Jim4', '4', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000004', 'Jim', 'Jim4', 5);
UPDATE hotel SET manager_ssn = '100000004' WHERE hotel_id = 5;
INSERT INTO users (username, password, type) VALUES ('Jim5', '5', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000005', 'Jim', 'Jim5', 6);
UPDATE hotel SET manager_ssn = '100000005' WHERE hotel_id = 6;
INSERT INTO users (username, password, type) VALUES ('Jim6', '6', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000006', 'Jim', 'Jim6', 7);
UPDATE hotel SET manager_ssn = '100000006' WHERE hotel_id = 7;
INSERT INTO users (username, password, type) VALUES ('Jim7', '7', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000007', 'Jim', 'Jim7', 8);
UPDATE hotel SET manager_ssn = '100000007' WHERE hotel_id = 8;
INSERT INTO users (username, password, type) VALUES ('Jim8', '8', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000008', 'Jim', 'Jim8', 9);
UPDATE hotel SET manager_ssn = '100000008' WHERE hotel_id = 9;
INSERT INTO users (username, password, type) VALUES ('Jim9', '9', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000009', 'Jim', 'Jim9', 10);
UPDATE hotel SET manager_ssn = '100000009' WHERE hotel_id = 10;
INSERT INTO users (username, password, type) VALUES ('Jim10', '10', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000010', 'Jim', 'Jim10', 11);
UPDATE hotel SET manager_ssn = '100000010' WHERE hotel_id = 11;
INSERT INTO users (username, password, type) VALUES ('Jim11', '11', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000011', 'Jim', 'Jim11', 12);
UPDATE hotel SET manager_ssn = '100000011' WHERE hotel_id = 12;
INSERT INTO users (username, password, type) VALUES ('Jim12', '12', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000012', 'Jim', 'Jim12', 13);
UPDATE hotel SET manager_ssn = '100000012' WHERE hotel_id = 13;
INSERT INTO users (username, password, type) VALUES ('Jim13', '13', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000013', 'Jim', 'Jim13', 14);
UPDATE hotel SET manager_ssn = '100000013' WHERE hotel_id = 14;
INSERT INTO users (username, password, type) VALUES ('Jim14', '14', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000014', 'Jim', 'Jim14', 15);
UPDATE hotel SET manager_ssn = '100000014' WHERE hotel_id = 15;
INSERT INTO users (username, password, type) VALUES ('Jim15', '15', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000015', 'Jim', 'Jim15', 16);
UPDATE hotel SET manager_ssn = '100000015' WHERE hotel_id = 16;
INSERT INTO users (username, password, type) VALUES ('Jim16', '16', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000016', 'Jim', 'Jim16', 17);
UPDATE hotel SET manager_ssn = '100000016' WHERE hotel_id = 17;
INSERT INTO users (username, password, type) VALUES ('Jim17', '17', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000017', 'Jim', 'Jim17', 18);
UPDATE hotel SET manager_ssn = '100000017' WHERE hotel_id = 18;
INSERT INTO users (username, password, type) VALUES ('Jim18', '18', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000018', 'Jim', 'Jim18', 19);
UPDATE hotel SET manager_ssn = '100000018' WHERE hotel_id = 19;
INSERT INTO users (username, password, type) VALUES ('Jim19', '19', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000019', 'Jim', 'Jim19', 20);
UPDATE hotel SET manager_ssn = '100000019' WHERE hotel_id = 20;
INSERT INTO users (username, password, type) VALUES ('Jim20', '20', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000020', 'Jim', 'Jim20', 21);
UPDATE hotel SET manager_ssn = '100000020' WHERE hotel_id = 21;
INSERT INTO users (username, password, type) VALUES ('Jim21', '21', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000021', 'Jim', 'Jim21', 22);
UPDATE hotel SET manager_ssn = '100000021' WHERE hotel_id = 22;
INSERT INTO users (username, password, type) VALUES ('Jim22', '22', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000022', 'Jim', 'Jim22', 23);
UPDATE hotel SET manager_ssn = '100000022' WHERE hotel_id = 23;
INSERT INTO users (username, password, type) VALUES ('Jim23', '23', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000023', 'Jim', 'Jim23', 24);
UPDATE hotel SET manager_ssn = '100000023' WHERE hotel_id = 24;
INSERT INTO users (username, password, type) VALUES ('Jim24', '24', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000024', 'Jim', 'Jim24', 25);
UPDATE hotel SET manager_ssn = '100000024' WHERE hotel_id = 25;
INSERT INTO users (username, password, type) VALUES ('Jim25', '25', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000025', 'Jim', 'Jim25', 26);
UPDATE hotel SET manager_ssn = '100000025' WHERE hotel_id = 26;
INSERT INTO users (username, password, type) VALUES ('Jim26', '26', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000026', 'Jim', 'Jim26', 27);
UPDATE hotel SET manager_ssn = '100000026' WHERE hotel_id = 27;
INSERT INTO users (username, password, type) VALUES ('Jim27', '27', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000027', 'Jim', 'Jim27', 28);
UPDATE hotel SET manager_ssn = '100000027' WHERE hotel_id = 28;
INSERT INTO users (username, password, type) VALUES ('Jim28', '28', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000028', 'Jim', 'Jim28', 29);
UPDATE hotel SET manager_ssn = '100000028' WHERE hotel_id = 29;
INSERT INTO users (username, password, type) VALUES ('Jim29', '29', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000029', 'Jim', 'Jim29', 30);
UPDATE hotel SET manager_ssn = '100000029' WHERE hotel_id = 30;
INSERT INTO users (username, password, type) VALUES ('Jim30', '30', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000030', 'Jim', 'Jim30', 31);
UPDATE hotel SET manager_ssn = '100000030' WHERE hotel_id = 31;
INSERT INTO users (username, password, type) VALUES ('Jim31', '31', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000031', 'Jim', 'Jim31', 32);
UPDATE hotel SET manager_ssn = '100000031' WHERE hotel_id = 32;
INSERT INTO users (username, password, type) VALUES ('Jim32', '32', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000032', 'Jim', 'Jim32', 33);
UPDATE hotel SET manager_ssn = '100000032' WHERE hotel_id = 33;
INSERT INTO users (username, password, type) VALUES ('Jim33', '33', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000033', 'Jim', 'Jim33', 34);
UPDATE hotel SET manager_ssn = '100000033' WHERE hotel_id = 34;
INSERT INTO users (username, password, type) VALUES ('Jim34', '34', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000034', 'Jim', 'Jim34', 35);
UPDATE hotel SET manager_ssn = '100000034' WHERE hotel_id = 35;
INSERT INTO users (username, password, type) VALUES ('Jim35', '35', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000035', 'Jim', 'Jim35', 36);
UPDATE hotel SET manager_ssn = '100000035' WHERE hotel_id = 36;
INSERT INTO users (username, password, type) VALUES ('Jim36', '36', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000036', 'Jim', 'Jim36', 37);
UPDATE hotel SET manager_ssn = '100000036' WHERE hotel_id = 37;
INSERT INTO users (username, password, type) VALUES ('Jim37', '37', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000037', 'Jim', 'Jim37', 38);
UPDATE hotel SET manager_ssn = '100000037' WHERE hotel_id = 38;
INSERT INTO users (username, password, type) VALUES ('Jim38', '38', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000038', 'Jim', 'Jim38', 39);
UPDATE hotel SET manager_ssn = '100000038' WHERE hotel_id = 39;
INSERT INTO users (username, password, type) VALUES ('Jim39', '39', 'employee');
INSERT INTO employee (ssn, name, username, hotel_id) VALUES ('100000039', 'Jim', 'Jim39', 40);
UPDATE hotel SET manager_ssn = '100000039' WHERE hotel_id = 40;