数据库的分类查询命令

Question

获得的数据

Answer 1

select typename, count(*) as count 
from question
group by typename

Answer 2

select count(*) as countNumber,typename as item from question group by typename;
试试这样写