如何对降序输出进行排序

Question

我有我的数据库，有医疗保险和人。我正在寻找的产出是，有多少人在健康保险公司#1，健康保险公司#2，等等。它也应该排序下降。

hicompany: (db 1)
id,name
1,abc
2,edf
3,ghi

people: (db 2)
code,company
0001,abc
0002,edf
0003,ghi

pupil: (db 3)
code
0001
0002
0003

下面是我的sql查询：

SELECT k.name AS hicompany, count( * ) AS howmany
ROM people p
JOIN hicompany k ON p.id= k.id
GROUP BY name

Answer 1

添加一个ORDER BY子句：

SELECT k.name AS hicompany, count( * ) AS howmany
FROM people p
JOIN hicompany k ON p.id= k.id
GROUP BY name
ORDER BY COUNT(*) DESC

Answer 2

只需在末尾添加这一行：

ORDER BY howmany DESC