Assignment
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.