Based on the SQL script file for Pine Valley Furniture Company, write the SQL statements for the following queries
1. List all customers
2. What is the address of the customer named Home Furnishing? Use Alias, Name for customer name.
3. Which Product has a standard price of less than $200? 4. What is the average standard price of products?
5. What is the price of most expensive product in inventory?
6. Count all orders.
7. How many different kinds of items were ordered on order number 1006?
8. Which order have been placed before 10/24/2007?
9. Alphabetically, what is the last product name in the PRODUCT table? Use an alias NAME.