count for 年龄<18 to n1count for 年龄>=18 and 年龄<25 to n2 count for 年龄>=25 and 年龄<30 to n3count for 年龄>=30 and 年龄<35 to n4count for 年龄>=35 and 年龄<40 to n5 * ...?n1,n2,n3,n4,n5
select field1,count(fielld1) as cnt from table1 group by field1