此SQL查询有什么问题？

一个流浪的小混混

以下查询返回“ ORA-00904错误：SATIS：无效的标识符”。当我删除该行时HAVING satis > 0，它可以工作。我该怎么办？
SELECT donem, bolge_adi, sehir_tasra "1=艦, 2=T",
       COUNT(DISTINCT mekankodu) "M.SAYISI",
       SUM(b2b_dagitim + b2b_transfer - b2b_iade) satis
FROM mps_view2
% q1 s( d. X1 p# C7 I; ~7 eWHERE donem IN ('200612','200712','200812','200912')
+ Q+ L* Q- k% v& }- ]' B4 M0 I! ~; qAND (ob IS NOT NULL OR b2b_ob IS NOT NULL)
GROUP BY donem, bolge_adi, sehir_tasra
HAVING satis > 0
ORDER BY donem, bolge_adi, sehir_tasra
               
- e; W2 X2 @5 K6 K解决方案: