Pregunta de entrevista de Aderant

Describe CTE and subquery execution differences; describe functional differences between RANK and DENSE_RANK.