Create an SQL query for each of the following requirements. Convert the requirement to logic, then to SQL.
Pay attention to the comments above as they describe what the attributes are.
1. Show me everything about each sale where the quantity purchased is greater than the average quantity purchased for that customer.
2. Show me the names of all products that have been sold.
3. Show me everything about any sale where the product sold does not exist in our list of products.
4. Show me the customers who have purchased all the products we sell.
5. Show me the customers who have not purchased all the products that we sell.
6. Show me any customers who have not purchased a product that we sell.
7. Show me everything about an customer who has purchased a product that does not exist in our list of products.
8. Show me customers who have purchased all products and have purchased them during the month of June 2010.
9. Show me the customers who have purchased all the products manufactured in Idaho ('ID') during the month of June 2010.
10. Show me the customers who have purchased all the products manufactured in Idaho ('ID') during the month of June 2010, and have purchased them from a branch in Arizona ('AZ').