Homework $4$

Please review the Sample Format for HW$4$ & HW$5$ and organize your submission

similarly.

SQL Exercises

Based on the SQL script file for Pine Valley Furniture Company, write the SQL statements

for the following queries

List all customers

What is the address of the customer named Home Furnishing? Use Alias, Name for

customer name.

Which Product has a standard price of less than $$200?$

What is the average standard price of products?

What is the price of most expensive product in inventory?

Count all orders.

How many different kinds of items were ordered on order number $1006?$

Which order have been placed before $2020-24-10?$

Alphabetically, what is the last product name in the PRODUCT table? Use an alias NAME.