Pregunta de entrevista de emids

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