Fall Term, 2005, BA271 Query Exam

This link leads to the Access database you should use when practicing this query quiz.
Your queries should be named Answer1, Answer2, Answer3, and Answer4. They should have identical column headings and number formatting as the images shown and described below.
The data in your database will be different from the data in my database when I captured the images shown below. Thus, your queries should have the same column headings and formatting, but they will produce a different number of rows and different values.

Answer1: Which Customers have placed the most orders?

Company Name should come from the Customers table.
Make this a "Top 5" query that is sorted in descending order based on Count of Orders, a calculated field that lists how many orders each Customer has placed.

Answer2: How much product was sold in the last two months of 1995 from each Supplier?

Company Name should come from the Suppliers table.
Total Sales should be calculated from the Order Details table as Unit Price times Quantity.
Limit the attention of the query to November and December 1995 based on the Shipped Date.
Make sure only one row appears for each Supplier in the query.
Either do not sort the query (the default), or sort it in ascending order based on Company Name (which results in the same thing).

Answer3: Which employee has given the largest discounts on products sold in Italy?

Answer4: How much Tofu has each Shipper delivered to Mexico, Canada, and the USA?