–count()举例
//数据:
1,mary,female,jiuye
4,white,male,jiuye
5,jack,male,jiuye
3,kitty,female,meijiuye
6,rose,female,meijiuye
2,tom,male,meijiuye
//创建countos表
create table if not exists countos(
id int,
name string,
sex string,
job string
)
row format delimited fields terminated by