Amazon Interview Question

Queries on window functions and other advanced DBMS concepts