select count(fyid) as appesfddpc from (select fyid,count(fyid) counts from jy510_esf_zhuzhai WHERE sfsh=1 AND  schoolpid like '238%' AND  schoolmid like '229%' AND fylx=1 AND mj>='150'  AND mj<='200'  AND fyid in (9749051,9710123,9725699,9720104,9709753,9714379,9701223,9738919,9744329,9750210,9750245,9696578,9735332,9749819,9748475,9623817,9750252,9745423,9706219,9750254,9745790,9739165,9737206,9626909,9750207,9623669,9748592,9732965,9716384,9656819,9748332,9746930,9750256,9750257,9732550,9747068,9750258,9750259,9750260,9750209,9746194,9706239,9739203,9684155,9676741,9746369,9715508,9717795,9710002,9748987,9670793,9697457,9739926,9697459,9734758,9746550,9744485,9740435,9674745,9672635,9703433,9687494,9744796,9739766,9735760,9742648,9725948,9722947,9677664,9750293,9674480,9750292,9736029,9729215,9734406,9746929,9723243,9341837,9631091,9708913,9725777,9691900,9656811,9685874,9748577,9535228,9744958,9743913,9617719,9750204,9717743,9742645,9690916,9738454,9742641,9690968,9750145,9740847,9645155,9683914,9745245,9737091,9742310,9744558,9735823,9607060,9605047,9733804,9724859,9749250,9707245,9729402,9748897,9718017,9741397,9732150,9738551,9729581,9746753,9735871,9748046,9750352,9745238,9750362,9750201,9747780,9735859,9733952,) AND mj > 0 AND jg > 0  group by xqid,mj,szlc ) temp