CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 73

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.
This is the end of Lab 7.
==============================================
CIS 336 Quiz 1 (Devry)

FOR MORE CLASSES VISIT
www.cis336study.com