SELECT count(aType) as numbers,aType FROM Articles group by aType
借用楼上的,SELECT cType ,count(*) from Articles group by cType
SELECT cType ,count(*) from Articles group by count(*)
