Rank family
rank leaves gaps after ties, dense_rank does not. A named WINDOW clause avoids repeating the definition.
task
Rank employees by salary inside each team, highest first, with rank and dense_rank side by side: columns emp_id, rank, dense_rank.