从customers表（包含customer_id、customer_name、city）中查询出每个城市（city）...

测试积点老人

从customers表（包含customer_id、customer_name、city）中查询出每个城市（city）的客户数量，并按照客户数量降序排列。

游客，如果您要查看本帖隐藏内容请回复

kallinr

SELECT city, COUNT(*) AS customer_count
FROM customers
GROUP BY city
ORDER BY customer_count DESC;

oliver.tang

order by

海海豚

SELECT city, COUNT(*) AS customer_count
FROM customers
GROUP BY city
ORDER BY customer_count DESC;

jingzizx

SELECT city, COUNT(*) AS customer_count
FROM customers
GROUP BY city
ORDER BY customer_count DESC;

你好浮戈

SELECT city, COUNT(*) AS customer_count
FROM customers
GROUP BY city
ORDER BY customer_count DESC;

litingting0214

SELECT city, COUNT(*) AS customer_count
FROM customers
GROUP BY city
ORDER BY customer_count DESC;