Pergunta de entrevista da empresa Gallagher

what is CTE and stored procedure?