mysql - GROUP BY mySQL 语句

Question

使用我的 SQL 列表，显示每个国家/地区的城市数量。你认为这个语句的意思是统计每个国家的城市数量吗？

+----+----------------+---------+---------------+------------+
| id | name           | country | original-name | population |
+----+----------------+---------+---------------+------------+
|  1 | Kabul          | AFG     | Kabol         | 1780000    |
|  2 | Qandahar       | AFG     | Qandahar      | 237500     |
|  3 | Herat          | AFG     | Herat         | 186800     |
|  4 | Mazar-e-Sharif | AFG     | Balkh         | 127800     |
|  5 | Amsterdam      | NLD     | Noord-Holland | 731200     |
|  6 | Rotterdam      | NLD     | Zuid-Holland  | 593321     |
|  7 | Haag           | NLD     | Zuid-Holland  | 440900     |
|  8 | Utrecht        | NLD     | Utrecht       | 234323     |
|  9 | Eindhoven      | NLD     | Noord-Brabant | 201843     |
| 10 | Tilburg        | NLD     | Noord-Brabant | 193238     |
+----+----------------+---------+---------------+------------+

我的代码可以工作，但超过 4000 行:

SELECT name, country 
FROM city 
GROUP BY name, country 
ORDER BY country ASC;

Answer 1

您只需按国家/地区分组:

SELECT country, COUNT(*) as count_of_cities_per_country
FROM city 
GROUP BY country 
ORDER BY country ASC;