Hi guys,

I am a newer for GEMFIRE OQL. Today I tried to write a quite simple GEMFIRE OQL statement, like the following

Code:
select a.bigcustno,
       a.bigcustname,
       a.sys_source,
       a.province_no,
       a.cust_id,
       nvl(sum(a.income_1), 0) income_1,
       nvl(sum(a.income_7), 0) income_7,
  from t_mon_inc_report_etl a
 where a.is_sanhu = '0'
   and a.area_no is not null
   and lower(a.area_no) <> 'null'
   and a.parent_id is not null
   and a.trade is not null
   and a.oper_time >= '201101'
   and a.oper_time <= '201109'
 group by a.bigcustno,
          a.bigcustname,
          a.sys_source,
          a.province_no,
          a.cust_id
 order by total_income desc
However, I found the keywords "group by", "order by", "sum" are not supported by GEMFIRE OQL. Could anyone point out some solution for this?

Thanks a lot