Cognizant interview question

Sql question with joins , and select statement