Kiwi.com Interview Question

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