Meta Interview Question

Sql, joins window functions, union