Finsih working on the Order database on the following queries using SQL statements.

List all the tables in the company that cost between 200 and $300 inclusive.

List product names by finish by name in ascending order.

Retrieve the names of customers who are NOT in Florida, New York and Texas and sort it by state in ascending order.

Display the total cost for each order that has been placed.

Retrieve the number of the customers in each state.

List average, highest, and lowest price of each product finish.

Display orders which have more than two products.

Display the product ID and the number of orders placed for each product. Show the results in decreasing order, and label result column NumOrders.

Create a view for product in natural ash color and display it.