Northwinds database in MS Access

Using the Northwinds database in MS Access, write the following queries and provide the results. (10 points each)Write a query that returns the number of customers in the customers table.Write a query that returns the number of customers in each job title.Write a query that returns the job titles having greater than 5 customers.Write a query that returns customer name, company, job title, phone, city and state for customers in Minnesota.Write a query that returns the Orders for Customer “Company AA”.Write a query that returns the order numbers for customer “Company AA” and the date of the orders.Write a query that returns the products ordered by “Company AA” for orders that are “Closed”.Write a query to return the quantity and sales total for each item on the “Company AA” open orders.Write a query to return the total sales amount for each of “Company AA” open orders.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.