Domanda di colloquio di Kiwi.com

Write complex SQL query using window functions (input table had > 1 million rows)