Online Movie Sales

Employee(F_Name, L_Name, E_ID, dob, addr_id, ssn)
Address(city, state, zip, street_name,street_num, addr_id)
Customer(C_name, dob, email, mailing_address, Customer_ID, addr_id)
Pays_with(Customer_ID, CC_num)
Places(Customer_ID, order_id)
Payment_Method(Payment_Type, Security_Code, CCNum, Date)
Type(type_name, type_id)
Payment_has_a_type(type_id,CC_num)
Status(Status_ID, status_name)
Supplier(S_name, Supp_ID)
Order_Paid_with(order_id, CC_num)
Processes(order_id, employee_id)
Movie(name, genre, release_date, run_time, language, sell_price, purchase_price, fan_rating, MPCR_rating, movie_id, movie_desc)
Customer Feedback(comments, ratings, recommend, feedback_id, customer_id)
Actor(actor_name, year_started, dob, hometown, actor_id)
MovieProduction(MP_name, budget, location, producer, director, publisher, production_ID)
Order(order_id, order_date, status_id)
Employee_make(employee_id,PO_id)
Purchase_Order(PO_id, PO_date, status_id)
Order Contains(order_id, movie_id, qty, sell_price)
Supplies(supplier_id, movie_id)
Consists_of(qty, purchase_price)
Receives(feedback_id, movie_id)
Contains actor(movie_id, actor_id)
Produced_by(movie_id, production_id)


1. List customers who have purchased action movies with two different types of credit cards between January 1st 2018 and February 2nd, 2018.

2. List all movies released in 2018 with a runtime less than two hours that features the actor Topher Grace.

3. List all comedy movies produced by Universal released before 5/6/2017 that contains actor Ryan Reynolds.

4. List all movies produced by Disney with a budget of more than $15 million released after 1/1/2000 that contain the same director.

5. List all employees who worked on all orders between 12/1/2018 to 12/25/2018.

6. List genres with ratings of 5 stars from 6/1/2018 to 12/20/2018

7. List customers who have placed more than 5 orders with a total of over $75.

8. List all customers who have purchased every horror film during the month of October.

9. List all customers that live in San Francisco who have bought every movie except the Avengers, within the last year.

10. List all customers that have only made one purchase.