Meta Interview Question

for SQL, there were questions around left join, null values, where clause