LAB OVERVIEW

Scenario and Summary

Lab 6 will introduce the concept of group functions and subqueries to meet more complex report

requirements. This lab will be completed using ACCESS and the Northwind database. If you need to,

review how to use ACCESS to execute SQL statements in my video demonstration in the Announcement

area.

Do your work in Notepad. When you create column name alias, you can use single quotes around the

column name in ACCESS.

1. Write a query to display the total number of orders in the database. Your display will be only one line. Give it the heading Total Number of Orders.

2. Write a query to display the total number of orders for each customer. Display the customer ID and display the total with a heading of Total Number of Orders Per Customer.

3. Write a query to display the total amount of orders in dollars. Your display will only be one line. Give the column the heading Total Dollars.

4. Write a query to display the number of orders in dollars for each customer. Give the column the heading Total Amount of Orders Per Customer. Sort by Customer ID.

Categories Employees Order Details Orders CustomerlD CategorylD CategoryName OrderlD OrderlD ProductiD Picture ContactTitle TitleOfC ourtesy RequiredDate ShippedDate Products ProductName Suppliers ShipPostalCode SupplierlD ReportsTo QuantityPerUnit ame Shippers ContactTitle Shipper!D CompanyName Phone