Try
Type your query or get one at random
1
rank(suppliers, [:status, :sid], :ranking)
+------+-------+---------+--------+----------+ | :sid | :name | :status | :city | :ranking | +------+-------+---------+--------+----------+ | S2 | Jones | 10 | Paris | 0 | | S1 | Smith | 20 | London | 1 | | S4 | Clark | 20 | London | 2 | | S3 | Blake | 30 | Paris | 3 | | S5 | Adams | 30 | Athens | 4 | +------+-------+---------+--------+----------+