oracle行列置换（1）

数据库中有张表：ACCOUNTS(OPERATEDATE date，OPERATEVALUE number(5))，存储数据如下：

 请写一个sql语句，查出的结果为：

sql语句如下： 

SELECT A.OPERATEDATE,
       SUM(DECODE(A.OPERATEVALUE - ABS(A.OPERATEVALUE),
                  0,
                  A.OPERATEVALUE,
                  NULL)) IN_OPERATEVALUE,
       SUM(DECODE(A.OPERATEVALUE + ABS(A.OPERATEVALUE),
                  0,
                  ABS(A.OPERATEVALUE),
                  NULL)) OUT_OPERATEVALUE
  FROM ACCOUNTS A
 GROUP BY A.OPERATEDATE;