Deliverable. Use the Pine Valley database to answer each of the questions. Each question must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font:
Include the SQL statement a screen shot of each query, each screen shots must include both the SQL statement and the results for each item below based on the data entered.
The screen shots must be large enough for the instructor to clearly read the results without a magnifying glass!
Your short explanation of the query and results
Caution: Read the instructions carefully! Each question is based on a single SQL statement, and the single SQL statement might contain sub-queries (additional SELECT statements) within the statement.
1. Provide a list all of the Customer ID, Customer Names, City and States and sort the list in alphabetical order by City.
2. Provide a list of all of the Customer ID, Customer Names, and States, and sort the list by state with the
3. Customer Names in alphabetical order within each state.
4. What is the full address of the customer named Furniture Gallery? That includes the street, city, state, and zip code
5. Provide a list of the product name, product ID, and unit price for all of the products in the Product table, sorted in alphabetical order by product name
6. What is the standard price and standard price if increased by 20% for every product?
7. What is the average standard price for the products with a product finish of natural ash?