Coforge Interview Question

Joins on SQL.. problem statement