+------+-------+--------+------------+--------+-------+
| :pid | :name | :color | :weight    | :city  | :rank |
+------+-------+--------+------------+--------+-------+
| P1   | Nut   | Red    | 12.0000000 | London |     0 |
| P5   | Cam   | Blue   | 12.0000000 | Paris  |     0 |
| P4   | Screw | Red    | 14.0000000 | London |     2 |
| P2   | Bolt  | Green  | 17.0000000 | Paris  |     3 |
| P3   | Screw | Blue   | 17.0000000 | Oslo   |     3 |
| P6   | Cog   | Red    | 19.0000000 | London |     5 |
+------+-------+--------+------------+--------+-------+