在语句计数计数列时如何使用案例

Question

SELECT DISTINCT f.location_name, COUNT (*) AS COUNT
FROM fastfood
GROUP BY f.location_name;

嗨，我想做的是计数计数列，因此我可以看到多少位置有一个计数，有多少位置的计数为2，等等。 有人可以帮助吗？ 谢谢你！

Answer 1

SELECT counter,count(*) how_many FROM (
  SELECT location_name, COUNT(*) AS COUNTER
  FROM fastfood 
  GROUP BY location_name
) a GROUP BY counter