Pregunta de entrevista de Cognizant

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