SQL Like a Pro: Window Functions

You probably use window functions already… but have you taken them this far?

Photo by Roman Synkevych on Unsplash

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…