Answer the following queries using the Pine Valley Furniture (PVFC) database. The questions may not specifically tell you which table to look at; that's part of learning to translate a need for information into a query that can generate meaningful data from the database. 1. List all customers in for Pine Valley Furniture from Florida.
2. Add yourself as a customer to the Pine Valley database.
3. Update the price of 8-drawer desks to $900.
4. We just got a notice of a recall on Entertainment Centers (apparently the doors are falling off and hitting children on the head). Write a query to return the ProductID of recalled items.
5. Find all products finished to look like Ash, and generate a list; ordered by price from highest to lowest.
6. Write a query to show the quantity and total value (i. e., sum of prices) of all Ash products of the same type.
7. List the product ID, description, finish and standard_price for all products whose cost is greater than the average cost of all products.