Rank with ties broken by a second column

Topic: sql, Subqueries, CTEs & Window Functions. Level: Advanced.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.