Chapter 1, Problem 1.48PAE

Helen Jarvis wants to determine the most important customers for Home Office products. She requests a listing of year-to-date total dollar sales for each customer who bought these products, as revealed by invoiced payments. The list is to be sorted in descending order so that the largest customer heads the list.

1. Look at Figure 1-16 and determine what entities are required to produce this list.
2. Which entities will be involved in the SQL query that will give Helen the information she needs?