**Deliverable 1: Simple SQL Statements**

Use the Pine Valley database to answer each of the following questions. Ensure each question within Deliverable 1 begins on a new page, and document the question as the title of each item at the top of each page. Use a 12-point font, include the SQL statement in your Word document, and provide a screenshot of each query. The screenshots must include both the SQL statement and the results, based on the data entered in Task 1. Make sure the screenshots are large enough for the instructor to clearly read the results. Read the instructions carefully! Each question is based on a single SQL statement, which may contain sub-queries (additional SELECT statements).

a. Provide a list of all customer IDs, customer names, and states, sorted in alphabetical order by customer name.

b. Provide a list of all customer IDs, customer names, and states, sorted by state, with customer names in alphabetical order within each state.

c. What is the full address of the customer named "Kaneohe Homes"? Include the name, street, city, state, and zip code.

d. Provide a list of the product name, product ID, and unit price for all products in the product table, sorted in alphabetical order by product name.

e. What is the standard price and the standard price increased by 15% for every product? Include identifying information such as the product ID and product description. Ensure your column headings are informative.

f. What is the average standard price for products with a product finish of "Natural Ash"?

g. Provide a listing of all products that includes the difference between their standard price and the overall average standard price of all products. Include product identifying information, the standard price, the average standard price, and the difference. Ensure the column headings are informative.