Refer to the exhibit.
You are assigned to do an end of the year sales analysis of 1, 000 different products, based on the transaction table. Which column in the end of year report requires the use of a window function?
A.
Total Sales to Date
B.
Daily Sales
C.
Average Daily Price
D.
Maximum Price
anyonecan explain? why answer A?
0
0
Total sales to date keeps track of the running total. Hence, by the end of the table, the last row will essentially have the total sales to date.
0
0