Pregunta de entrevista de Tata Consultancy Services

sql joins question based on given table