Capital imputation Rate SQL

Temporary

Select Bd_glorgbook.glorgbookcode,
NVL (replace (bd_glorgbook.glorgbookname, ' group benchmark Book ', '), ' subtotal ') company name,--Learn from radish

Bd_accsubj.subjcode,bd_accsubj.subjname,
SUM (case at gl_balance.year= ' then Gl_balance.debitamount else 0 end) "2012 occurrences",
SUM (case if gl_balance.year= ' then Gl_balance.debitamount else 0 end) "2013 occurrences",
SUM (case if gl_balance.year= ' then Gl_balance.debitamount else 0 end) "2014 occurrences",
SUM (case if gl_balance.year= ' then Gl_balance.debitamount else 0 end) "2015 occurrences"

From Gl_balance, BD_ACCSUBJ, Bd_glorgbook
where gl_balance.pk_accsubj = Bd_accsubj.pk_accsubj
and Bd_glorgbook.pk_glorgbook = Gl_balance.pk_glorgbook
and bd_glorgbook.glorgbookcode like ' 01%-0001 '
and (Bd_accsubj.subjcode like ' 2123% ' or bd_accsubj.subjcode like ' 1131% ' or bd_accsubj.subjcode like ' 1111% ')
and Gl_balance.period<> ' 00 '
and Gl_balance.year in (' 2012 ', ' 2013 ', ' 2014 ', ' 2015 ')
GROUP BY Bd_glorgbook.glorgbookcode, Rollup ((Bd_accsubj.subjcode,bd_accsubj.subjname, Bd_glorgbook.glorgbookname))

Order by Bd_glorgbook.glorgbookcode, Bd_accsubj.subjcode

Capital imputation Rate SQL