mlr --csv sort -f dept -nr salary data.csv

Sorts on two keys in priority order: dept first (ascending, text), then salary within each department (numeric descending). The sort verb applies -f and -nr flags as a key list, so this ranks the highest-paid people first inside every department. Multi-key sorting is the standard way to prepare ranked reports. Add more -f or -nr flags to extend the key chain.