select count(fyid) as appesfddpc from (select fyid,count(fyid) counts from jy510_esf_zhuzhai WHERE sfsh=1 AND  schoolpid like '249%' AND fylx=1 AND jg>'80' AND jg<='100' AND fyid in (9741662,9672190,9618402,9749142,9614839,9749154,9749160,9673597,9582949,9551116,9748959,9740428,9708902,9634407,9634183,9683158,9727581,9710935,9603669,9651693,9611049,9714787,9739611,9710880,9750462,9750467,9710553,9703708,9543203,9739858,9724427) AND jg > 0  group by xqid,mj,szlc ) temp