GROUP BY 地區(qū)代碼，品牌類型，業(yè)務(wù)類型，SP代碼，套餐編號，TO_CHAR(入網(wǎng)時間，‘YYYYMM’)，DECODE(停開狀態(tài)，‘00000‘，‘否‘，‘是‘)
HAVING SUM(計次信息費+包月信息費)>1000;
2、步驟四的代碼案例
DELETE STAT_MW_WG_ZXF
WHERE 月份 = p_月份 AND
SP代碼 IN (S-ELECT SP代碼 FROM STAT_MW_WG_ZXF WHERE 月份=p_月份 GROUP BY SP代碼
HAVING SUM(總信息費)<10000);
DELETE STAT_MW_WG_ZXF
WHERE 月份 = p_月份 AND
(地區(qū)名稱， 品牌名稱) IN (S-ELECT 地區(qū)名稱， 品牌名稱 FROM STAT_MW_WG_ZXF WHERE 月份=p_月份
GROUP BY 地區(qū)名稱， 品牌名稱 HAVING SUM(總信息費)<20000);
DELETE STAT_MW_WG_ZXF
WHERE 月份 = p_月份 AND
(地區(qū)名稱，品牌名稱，套餐編號，入網(wǎng)月份 ) IN (S-ELECT 地區(qū)名稱，品牌名稱，套餐編號，入網(wǎng)月份 FROM STAT_MW_WG_ZXF
WHERE 月份=p_月份 GROUP BY 地區(qū)名稱，品牌名稱，套餐編號，入網(wǎng)月份 HAVING SUM(總信息費)<3000);
DELETE STAT_MW_WG_ZXF
WHERE 月份 = p_月份 AND
SP代碼 IN (S-ELECT SP代碼 FROM STAT_MW_WG_ZXF WHERE 月份=p_月份 GROUP BY SP代碼
HAVING SUM(總信息費)<10000);