Amazon Interview Question

SQL - They asked to write a query using Rank