此SQL查询有什么问题？

一个流浪的小混混

以下查询返回“ ORA-00904错误：SATIS：无效的标识符”。当我删除该行时HAVING satis > 0，它可以工作。我该怎么办？
  W: |8 p* p* z5 e5 Q7 E! GSELECT donem, bolge_adi, sehir_tasra "1=艦, 2=T",
       COUNT(DISTINCT mekankodu) "M.SAYISI",
6 @# {* ~6 {4 ~7 z/ k# r       SUM(b2b_dagitim + b2b_transfer - b2b_iade) satis
) C/ E4 z8 E) ]0 m5 \FROM mps_view2
WHERE donem IN ('200612','200712','200812','200912')
AND (ob IS NOT NULL OR b2b_ob IS NOT NULL)
0 o5 ]7 t/ c2 v( e9 ZGROUP BY donem, bolge_adi, sehir_tasra
HAVING satis > 0
ORDER BY donem, bolge_adi, sehir_tasra
               
2 P# G4 u+ N0 i/ @" c; O5 ^+ X+ y解决方案: