Question d’entretien chez emids

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