Infosys interview question

SQL queries based on joins.