Now write SQL queries to answer the following questions.

1. Find the average unit retail amount for electronic items purchased by Advantage members at Store 20 in January, 2000. Hint: Advantage Members are indicated by member_type 'V'. Category 5 is Electronics. For dates use the format 20000131 for Jan 31, 2000
2. Find the markup rate for items purchased in January, 2000 from any store in Wisconsin WI for the item vendor is Vendor of 11110.
3. What is the total quantity of items sold in WI between Jan.1,2000 and Jan.7, 2000?
4. How many different members visited stores in WI between Jan.1, 2000 and Jan.7, 2000?
5. Count the number of different customers (members) who bought an item with a CLEAR color in Texas and spent more than $50.
6. Count the number of different stores that sold HAMBURGER BUNS on Jan 5, 2000 to members with a member status code of A.
7. The Sams Club management wants

8. a count of how many unique members who shopped in January, 2000?

   b count of how many unique members who shopped in Store 3 on Jan 3, 2000?

9. Management needs to know the dates (if any) on which anyone purchased 2 ALARM CHILI in WI.
10. Management also needs a count of the number of times that any product whose description contains BODYWASH was purchased (visits) in any store in Florida FL in January, 2000
11. Sams Club management needs the purchasing member number, item description, and price for the most expensive item(s) purchased in Wisconsin WI on January 3^rd, 2000.