-- Description: Summary GL report including one line per account segment level, including product code, with opening balance, total transaction amount per month for each period selected, and closing ...
(Select nvl(D.Name,'NULL') Doctor, nvl(P.Name,'NULL') Professor, nvl(S.Name,'NULL') Singer, nvl(A.Name,'NULL') Actor (Select Name, row_number() over (partition by ...