Try

Type your query or get one at random

1
ungroup(group(suppliers, [:city], :suppliers, allbut: true), :suppliers)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
+--------+------+-------+---------+
| :city  | :sid | :name | :status |
+--------+------+-------+---------+
| London | S1   | Smith |      20 |
| London | S4   | Clark |      20 |
| Paris  | S2   | Jones |      10 |
| Paris  | S3   | Blake |      30 |
| Athens | S5   | Adams |      30 |
+--------+------+-------+---------+