Coforge interview question

Joins on SQL.. problem statement