Frage im Vorstellungsgespräch bei Aderant

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