Using Window Functions

Any and all aggregate functions we already know can be used against a window frame rather than a grouping clause, so we can start to use sum, min, max, count, avg, and the others that we’re already accustomed to.