Using the Northwinds database in MS Access, write the following queries and provide the results

Using the Northwinds “database” in MS Access, write the following queries and provide the results.  

  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
Posted in Uncategorized