Pregunta de entrevista de Cognizant

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