SELECT province
,æ»äººæ°
,ç·
,女
,CASE 女 WHEN 0 THEN 0 ELSE ç·/女 END AS ç·å¥³æ¯ä¾
FROM (
SELECT province
,COUNT(*) AS æ»äººæ°
,SUM(CASE gender WHEN 'ç·' THEN 1 ELSE 0 END) AS ç·
,SUM(CASE gender WHEN '女' THEN 1 ELSE 0 END) AS 女
GROUP BY province
)
追é®![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/80cb39dbb6fd5266bb7d655aae18972bd407362d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
ä¸å¯¹åï¼äº² æ¯ä¸æ¯åªéä¸å¯¹åï¼
追çæååæ¹æè±æå§
SELECT province
,Total AS æ»äººæ°
,Male AS ç·
,Female AS 女
,CASE Female WHEN 0 THEN 0 ELSE Male/Female END AS ç·å¥³æ¯ä¾
FROM (
SELECT province
,COUNT(*) AS Total
,SUM(CASE gender WHEN 'ç·' THEN 1 ELSE 0 END) AS Male
,SUM(CASE gender WHEN '女' THEN 1 ELSE 0 END) AS Female
GROUP BY province
) Data