Domanda di colloquio di emids

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