Amazon Interview Question

SQL pseudo code asked on Use of SQL windows function