sql排序语句工作不正常

Question

SELECT country, COUNT(country) as total FROM user GROUP BY country ASC

我正在使用此语句来显示表中的记录并显示它们。它根据国家显示记录并对其进行排序。我需要根据总数对记录进行排序。并相应地显示它们。即，我想按DESC顺序显示计数。

Answer 1

SELECT country, COUNT(country) as total 
FROM user 
GROUP BY country 
order by total desc