Create a query that shows a list of all the products (i.e. product id and product description) and the number of times that each product has been ordered. How many products have been order less than 10 times?

Create a query that shows the customer id, customer name, and order ID for all customers with the words furniture in their name. How many records are there in your result set (Hint: for this one, you need to use the wildcard *)? Only enter the numeric value below. e.g. 12

Create a query that shows the order number and order quantity for all customer orders for which the order quantity is greater than the average order quantity of that product. How many such orders are there? Only enter the numeric value below. e.g. 12

Create a query that the name of the sales person who sold the most number of computer desks between 1 January 2004 and 31 December 2005 (Hint: for this one, the difficulty is to figure out which tables you need for the query. Make sure that your tables on the query grid are connected)?

Who supervises employees with the skill 12 in BandSaw? (Hint: for this one, you need to find out the supervisor ID first, then figure out the supervisors name.)

Create a query that shows the name of the customer who placed the most number of orders in 2006. How many different orders did that customer place in 2006?

Create a query that shows the Customer Names, Addresses and States of all customers who placed orders. How many customers placed orders?

Create a query that shows the Customer Name, Address and State of all customers who did not place any orders. How many customers did not place any orders?

Create a query that show the product description product finish and product standard price for all the products that have a standard price between $200 and $500. How many products have a standard price between $200 and $500?

Create a query that shows the total dollar value of orders for each sales territory from 10/21/2004 to 10/29/2011. What is the total dollar value of orders for the North East sales territory during this period? (Hint: for this one, you need to create a query (part 1) to figure out the total dollar value (order qty*standard Price) for each order first. Then you need to query a second query based on part 1 query to figure out what is the total for each territory.)

Create a query that shows the name and the addresses of the customer that placed order number 1008. What is the name of that customer?