You probably use window functions already… but have you taken them this far? — Window functions are (in my opinion) one of the best inventions in SQL language. Why, might you ask? Using the SQL core language, without window functions, all you can do is compare columns with columns. Yes, it is true you can join tables to themselves, but sequencing rows is still…