1. Supplier names of those with Net30 payment terms with a contract date starting before the year 2000

2. Product names of discontinued products

3. Product names that have a unit price greater than 50 cents with category BA or CA

4. List category in alphabetical order and by unit price most expensive first.

5. Determine the average unit price for each category

6. Determine the total cost for each category using the average unit price (instead of the individual unit prices like done in the slides)

Both of these query3’s are equivalent; either way if fine