emids interview question

Gave some SQL queries to write..1 on window function, 1 on left join.