Q2 Software interview question

write SQl query on joins