-- windows functions are really powerful and are somewhat like a group by - except they don't roll everything up into 1 row when grouping. -- windows functions allow us to look at a partition or a ...

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.