theater_insert.sql

-- Insert into Customers Table
insert into customers(first_name, last_name, contact_number)
values('Harry', 'Hill', 2039624178);

-- Insert into Movies Table
insert into movies(movie_name)
values('A New Hope');

insert into movies(movie_name)
values('The Mummy');

insert into movies(movie_name)
values('Hot Fuzz')

-- Insert into Tickets Table
-- all values are primary keys, a generated current date, or a foreign key
-- all inserted upon creation of table

-- Insert into Inventory Table
insert into inventory(product_amount)
values(36)

insert into inventory(product_amount)
values(71)

insert into inventory(product_amount)
values(5)

-- Insert into Concessions Table
insert into concessions(item_name, price)
values("Reese's Pieces", 6.99)

insert into concessions(item_name, price)
values("Junior Mints", 4.99)

insert into concessions(item_name, price)
values("Sour Patch Kids", 5.99)