select count(distinct ex.C0007_SUBSTATION_ID) sum,ex.C0003_STNAME,ex.C0003_STCODE from V_WA_Exceed ex,t0003_station t3 where t3.c0003_stcode=ex.C0003_STCODE and
ex.C0001_ITEM_CODE in (201,203,210)
group by ex.C0003_STNAME,ex.C0003_STCODE
ex.C0001_ITEM_CODE in (201,203,210)
group by ex.C0003_STNAME,ex.C0003_STCODE