Boingo Interview Question

Perform a SQL Query requiring a Left Join