Continue working on your Order database on the following queries using SQL statements. Copy and past 1) query question, 2) SQL statement and 3) SQL output to a word file, and print it out.

1. Retrieve the average, highest, and lowest price of each product finish.

2. Display customer names who have made 2 orders.

3. Display the order IDs and the number of products placed for each order.

4. Create a view for customer in Texas and New York.

Example for three output: Query, SQL and output Display the SKU description for the buyer Pete Hansan. SELECT SKU_DESCRIPTION FROM SKU_DATA WHERE Buyer = 'Pete Hansen';

CUSTOMER CustomerlD CustomerName CustomerAddress CustomerCity CustomerState CustomerPostalCode ORDER OrderlD OrderDate CustomerlD ORDER LINE OrderlD ProductID OrderedQuantity PRODUCT ProductID ProductDescription ProductFinishl ProductStandardPrice ProductLinelID