select case when IS_AUTO_VISIT='男' then '男' else '女' end 性别,count(*) 总数 from student group by
case when IS_AUTO_VISIT='男' then '男' else '女' end;
select 性别,count(*) 人数 from student group by 性别;
select case when IS_AUTO_VISIT='男' then '男' else '女' end 性别,count(*) 总数 from student group by
case when IS_AUTO_VISIT='男' then '男' else '女' end;
select 性别,count(*) 人数 from student group by 性别;