Boingo interview question

Perform a SQL Query requiring a Left Join