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?

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

View Answer

Answer: A