--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 group ...
--normally when you start the EDA process you have some idea of what you're looking for ...