Cognizant Interview Question

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