FIS interview question

SQL Joins and queries