Northwinds database in MS Access

Using the Northwinds database in MS Access, write the following queries and provide the results. (10 points each)

 

  1. Write a query that returns the number of customers in the customers table.
  2. Write a query that returns the number of customers in each job title.
  3. Write a query that returns the job titles having greater than 5 customers.
  4. Write a query that returns customer name, company, job title, phone, city and state for customers in Minnesota.
  5. Write a query that returns the Orders for Customer “Company AA”.
  6. Write a query that returns the order numbers for customer “Company AA” and the date of the orders.
  7. Write a query that returns the products ordered by “Company AA” for orders that are “Closed”.
  8. Write a query to return the quantity and sales total for each item on the “Company AA” open orders.
  9. Write a query to return the total sales amount for each of “Company AA” open orders.
  10. Write a query that returns who created and approved the purchase order for “Company AA”  “Closed” orders along with the internal notes on the purchase order.