Cognizant interview question

SQL Joins Questions