Pergunta de entrevista da empresa Cognizant

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