Q2 Software Interview Question

write SQl query on joins