Futurense Technologies interview question

For SQL, make sure you read up on SQL Joins.