mysql - 在 SQL 中获取带有 COUNT 的行的名称

Question

这是我当前的查询:

SELECT COUNT(`location`) AS 'amount' FROM offers GROUP BY location;

返回:

但是，我希望能够将每个数字归因于值。例如，它会输出:

基本上，组

SELECT COUNT(`location`) AS 'amount' FROM offers GROUP BY location;

和

SELECT location FROM offers GROUP BY location;

进入一个查询

Answer 1

尝试:

SELECT location, COUNT(location) AS amount
FROM offers
GROUP BY location