Cognizant interview question

SQL theory part..mostly related to joins and a simple coding question