Nokia Interview Question

About Joins in Database and sql queries.