Exercise

Aggregate window functions

There are several aggregate window functions available to you. In this exercise, we will look at reviewing multiple aggregates over the same window.

Our window this time will be the entire data set, meaning that our OVER() clause will remain empty.

Instructions

100 XP

Fill in the correct aggregate function for each column in the result set.

Take Hint (-30 XP)