mysql> SELECT a.* FROM city a WHERE a.population > (SELECT max(population) FROM city WHERE name = 'London');
+-------------+---------+-------------------+------------+-----------+----------+
| Name        | Country | Province          | Population | Longitude | Latitude |
+-------------+---------+-------------------+------------+-----------+----------+
| Beijing     | TJ      | Beijing (munic.)  |    7000000 |     116.2 |     39.5 |
| Hong Kong   | HONX    | Hong Kong         |    7055071 |     114.2 |     22.3 |
| Istanbul    | TR      | Istanbul          |    7615500 |   28.8333 |  40.9667 |
| Jakarta     | RI      | Indonesia         |    8259266 |     106.5 |     -6.1 |
| Karachi     | PK      | Pakistan          |    9863000 |     66.98 |     24.8 |
| Mexico City | MEX     | Distrito Federal  |    9815795 |     -99.2 |     19.4 |
| Moscow      | R       | Moskva            |    8717000 |   37.6667 |  55.7667 |
| Mumbai      | IND     | Maharashtra       |    9925891 |      72.5 |       19 |
| New Delhi   | IND     | Delhi             |    7206704 |      77.2 |  28.5833 |
| New York    | USA     | New York          |    7322564 |       -74 |     40.4 |
| Sao Paulo   | BR      | Sao Paulo         |    9811776 |  -46.6333 |   -23.55 |
| Seoul       | ROK     | South Korea       |   10229262 |   126.967 |  37.5667 |
| Shanghai    | TJ      | Shanghai (munic.) |    7830000 |   121.433 |     31.2 |
| Tokyo       | J       | Tokyo             |    7843000 |   139.767 |  35.6833 |
+-------------+---------+-------------------+------------+-----------+----------+
14 rows in set (0.00 sec)