[Solved] CSE3330 Homework #5

Using the ClassicModels database, answer the following questions.

Provide the data that answers the question AND the SQL used to answer the question. Each query should include at least one join.

1. How many products were not ordered?

2. What Dates did Customers from postalCode 69004 make Payments?

3. Who manages an employee with a title of VP Sales?

4. What is the total Price for products with productLine Motorcycles that were ordered on 2003-03-03? (Note: priceEach is not the right value)

5. What are the employeeNumbers for the employees that have the jobTitle of Sales Rep and work in London?