Quantiphi interview question

About SQL Queries and Joins