Spring Term, 2006, BA271 Query Exam
This link leads to the Access database you should
use when practicing this query quiz.
Answer1: What products have Ann Devon bought
from Davolio?
|
Answer2: Write a query
that lists the Supplier table's Contact Name, Sales
(calculated as Quantity times Unit Price) and Order
Date for all orders whose Order Date was in the last
three months of 1995 and where the Required Date minus the
Shipped Date is negative.
|
Answer3: Which Company has shipped the most
items of Produce to Germany?
|
Answer4: What are the top 5 companies that have
bought Produce?
| |
