--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 ...
--A Case Statement allows you to add logic to your Select Statement, sort of like an if else statement in other programming languages or even things like Excel ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results