CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 73

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 .