SELECT country,
SUM( CASE WHEN sex = '1' THENpopulation ELSE 0 END) 女,
SUM( CASE WHEN sex = '0' THEN
population ELSE 0 END) 男
FROM Table_A
GROUP BY country;
SELECT country,sum(false) 男,sum(true) 女
FROM Table_A
PIVOT (max(population) FOR sex IN(false,true)) p group by country