Aderant interview question

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