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. List all the desks in the company that cost between $400 and $700 inclusive.

2. List customer names by their state, city and names in all in the ascending order.

3. Retrieve the names of customers who are in Texas and California.

4. Display the total cost for each order that has been placed and rename the output columns.

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

6. Display customer names who have made 2 orders.

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

8. 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