I find that window functions are one of the least used aspects of modern SQL, despite them being incredibly useful. I've used them in T-SQL [1] and PL/SQL [2], as well (MySQL does not do window functions). If you're doing lots of SQL work, get very familiar with the OVER clause. It's a lifesaver.