CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 78

b. Display the data in the SalesData view sorted by artist_id.
Does this help you to “visualize” how to group the data to
create the totals?
c. Create a query USING THIS VIEW and the appropriate
aggregate function to display artist_id and the total sales for
each artist.
d. Now join to the artist table in order to display the
artist_name along with the total sales.
5. Now use this same method to display the total sales per
customer.
a. Create a view called SalesData with the appropriate data.
At a minimum you will need customer_id and the calculated
item total. DO NOT use the customer table in this view, it
will be joined later.
b. Display the data in your view sorted by customer_id. Does
this help you to “visualize” how to group the data to create
the totals?
c. Create a query USING THIS VIEW and the appropriate
aggregate function to display customer_id and the total sales
for each customer.
d. Now join to the customer table in order to display the
customer_name as a single field named Customer along with
the total sales. Sort the report by Total sales in descending
order.