1. How many orders were placed by customers in each state? Use the join facility to answer this question; do not use subqueries.
2. What is the total quantity of the products with a natural ash finish ordered by customers in each state? Only include states with a total quantity of at least 3. Use the join facility to answer this question; do not use subqueries.
3. Which products (of any finish) have a higher price than the lowest priced product with a Natural Ash finish? Include the prices in your results and order the results from lowest to highest id number. This calls for a subquery.
4. Which products (of any finish) in the Country Look product line have a higher price than the lowest priced product (of any product line) with a Natural Ash finish? Include the prices in your results and order the results from lowest to highest id number? This calls for a subquery.