语句如下：
SELECT Xs.yxzydm, SUM(IIF(Xsjy.jylx="基层就业",1,0)) AS 基层就业人数,;
SUM(IIF(Xs.zzmmdm="01",1,0))/CNT(Xs.xh) AS 党员所占比例;
FROM jxsj!xs INNER JOIN jxsj!xsjy ;
ON Xs.xh = Xsjy.xh;
GROUP BY Xs.yxzydm;
ORDER BY 3

告诉我告诉我告诉我啊！！！！