Pergunta de entrevista da empresa Mu Sigma

One of the good question was How is a subquery different from a CTE (Common Table Expression)?