Intuit Interview Question

use rank() functions in SQL.