Meta Interview Question

Right and left joins, group by for SQL