面试遇到的问题

题目一：

select t.name,
max(case when t.man_sex='1' then t.c else 0 end) '男',
max(case when t.man_sex='2' then t.c else 0 end) '女' from(
select name,man_sex,count(1) as c from dept_mianshi group by name,man_sex
) t group by name