Today's SQL Review: RANK(), DENSE_RANK() and PARTITION -- August-21-22

A frequent question on SQL Technical Interviews is : Which is the nth highest value in a column of numeric values. Let