+------+-------+--------+---------+--------+-------+ | :pid | :name | :color | :weight | :city | :rank | +------+-------+--------+---------+--------+-------+ | P1 | Nut | Red | 12.000 | London | 0 | | P5 | Cam | Blue | 12.000 | Paris | 0 | | P4 | Screw | Red | 14.000 | London | 2 | | P2 | Bolt | Green | 17.000 | Paris | 3 | | P3 | Screw | Blue | 17.000 | Oslo | 3 | | P6 | Cog | Red | 19.000 | London | 5 | +------+-------+--------+---------+--------+-------+