Meta interview question

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