This is from the "NorthWind" Company Database, here is the Schema. It may be hard to see, just zoom in on it, or look it up.

Write SQL statements for the following:

Help please! Thanks!

Here's a summary of the database: Products 1. What is the full name, full address, title, and phone number for all employees currently living in a US state that shares a border with the Pacific Ocean? 2. Give the same information for all employees not in the USA but are older than 50 years of age. 3. Which employees (last name, first name without repeats) have placed orders delivered to Norway? 4. What is the title and name of any employee that has sold at least two of either "Vegie-spread" or "Sir Rodney's Marmalade"? 5. What are the Employee IDs for all employees who have sold more than 70 products? 6. List the last name of all employees that live on the same city as their managers. 7. List the product names of all products that were bought OR sold by people who live in London (use a UNION ). 8. What is the average price of products for each category? Output just the average price as "average_price" and the category ID. Here's a summary of the database: Products 1. What is the full name, full address, title, and phone number for all employees currently living in a US state that shares a border with the Pacific Ocean? 2. Give the same information for all employees not in the USA but are older than 50 years of age. 3. Which employees (last name, first name without repeats) have placed orders delivered to Norway? 4. What is the title and name of any employee that has sold at least two of either "Vegie-spread" or "Sir Rodney's Marmalade"? 5. What are the Employee IDs for all employees who have sold more than 70 products? 6. List the last name of all employees that live on the same city as their managers. 7. List the product names of all products that were bought OR sold by people who live in London (use a UNION ). 8. What is the average price of products for each category? Output just the average price as "average_price" and the category ID