Pergunta de entrevista da empresa Cognizant

Regarding Joins, function, view, stored procedures, complex question, function