Capgemini interview question

procedure creation, analytical functions, procedure vs function