select name,
sum(case sex when "female" then tizhong else 0 end) as female ,
sum(case when sex="male" then tizhong else 0 end) as male,
sum(case when sex="unknown" then tizhong else 0 end) as unknown
from x
GROUP BY name;
select name,
sum(case sex when "female" then tizhong else 0 end) as female ,
sum(case when sex="male" then tizhong else 0 end) as male,
sum(case when sex="unknown" then tizhong else 0 end) as unknown
from x
GROUP BY name;