oracle查询同比语句

CREATE OR REPLACE VIEW F_WLAQYS_VW AS
select CC.DATEKEY,CC.XMLX,CC.ORG_ID,CC.BNYSED,CC.BNZXED,CC.QNYSED,CC.QNZXED,
  NVL(ROUND(CC.BNZXED / CC.QNZXED - 1, 4) * 100, 0) AS ZXETB
    from
   (SELECT AA.DATEKEY,AA.XMLX,AA.ORG_ID,AA.YSED AS BNYSED,AA.ZXED AS BNZXED,(
   SELECT BB.YSED FROM F_JZB_WLYS BB WHERE BB.DATEKEY=AA.DATEKEY-1 AND BB.ORG_ID=AA.ORG_ID
   ) AS QNYSED,
   (
   SELECT BB.ZXED FROM F_JZB_WLYS BB WHERE BB.DATEKEY=AA.DATEKEY-1 AND BB.ORG_ID=AA.ORG_ID
   ) AS QNZXED FROM F_JZB_WLYS AA) CC;