Cognizant interview question

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