CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 74

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.

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.