Labcorp Interview Question

question of joins in sql