[This thread is associated with Part 19 of the SQL Credit series.]

Using the sample table and data presented here, can you come up with a worthwhile SELECT statement that uses RANK() or DENSE_RANK() in both the SELECT and ORDER BY clauses where they don’t match?

If this is never possible, can you explain why?