Pergunta de entrevista da empresa Tata Consultancy Services

sql joins question based on given table