Cognizant Interview Question

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