Yes, things like sum() can work on partitions. :) "Window functions" refer to something a little different... specifically to functions like row_number() and r

Yes, things like sum() can work on partitions. :) "Window functions" refer to something a little different... specifically to functions like row_number() and rank() that refer to the position/ordering of rows inside a partition.