LTM Limited interview question

Scenario based questions on database joins.