Meta interview question

Sql, joins window functions, union