Infosys interview question

Mostly SQL Joins and Subqueries