Hacker News Reader

This (in perhaps a slightly different syntax flavor) works on Hive/Presto/SparkSQL as well by the way. Also in Apache drill.

Presto implements the SQL standard, so the syntax is identical: https://prestodb.io/docs/current/functions/window.html