如何统计问题出现的次数》》如何统计问题出现的次数

[goodluck2018]

数据表qus
qus_id qus_name
1 打不开
2 打不开
3 中断网络
4 中断网络
5 中断网络
6 老掉线
7 老掉线
8 老掉线
....
如何得到
问题 问题出现的次数
打不开 2
中断网络 3
老掉线 3

[问苍天人生几何]

select qus_name 问题,count(qus_name) 问题出现的次数 from qus
group by qus_name

[筱筱澄]

select 问题,count(*) as 问题出现的次数
from tb group by 问题

[quchen520]

select count(qus_id ), qus_name from tb
group by name

[quchen520]

select count(qus_id ), qus_name from tb
group by name

[zhulihui133]

select qus_name as "问题",count(*) as "问题出现的次数" from qus group by qus_name