+- Input[@CanonicalImage = null, @ExcludedLinesCount = 0, @ExcludedRangesCount = 0]
   +- Global[@CanonicalImage = null]
      +- Block[@CanonicalImage = null]
         +- Statement[@CanonicalImage = null]
            +- UnlabelledStatement[@CanonicalImage = null]
               +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
                  +- SelectList[@CanonicalImage = null]
                  |  +- SqlExpression[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "DECODE", @Image = "DECODE", @SelfModifier = false]
                  |  |     +- FunctionCall[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |        +- FunctionName[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |        |  +- ID[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |        +- Arguments[@ArgumentCount = 4, @CanonicalImage = null]
                  |  |           +- ArgumentList[@CanonicalImage = null]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |              |  +- Expression[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |     +- PrimaryPrefix[@CanonicalImage = "GROUPING", @Image = "GROUPING", @SelfModifier = false]
                  |  |              |        +- FunctionCall[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |           +- FunctionName[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |           |  +- ID[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |           +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
                  |  |              |              +- ArgumentList[@CanonicalImage = null]
                  |  |              |                 +- Argument[@CanonicalImage = null]
                  |  |              |                    +- Expression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |              |                       +- PrimaryPrefix[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name", @SelfModifier = false]
                  |  |              |                          +- SimpleExpression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |              |                             +- Column[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |              |                                +- ID[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |              |  +- Expression[@CanonicalImage = "1", @Image = "1"]
                  |  |              |     +- PrimaryPrefix[@CanonicalImage = "1", @Image = "1", @SelfModifier = false]
                  |  |              |        +- Literal[@CanonicalImage = "1", @Image = "1"]
                  |  |              |           +- NumericLiteral[@CanonicalImage = "1", @Image = "1"]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |              |  +- Expression[@CanonicalImage = "\'ALL DEPARTMENTS\'", @Image = "\'All Departments\'"]
                  |  |              |     +- PrimaryPrefix[@CanonicalImage = "\'ALL DEPARTMENTS\'", @Image = "\'All Departments\'", @SelfModifier = false]
                  |  |              |        +- Literal[@CanonicalImage = "\'ALL DEPARTMENTS\'", @Image = "\'All Departments\'"]
                  |  |              |           +- StringLiteral[@CanonicalImage = "\'ALL DEPARTMENTS\'", @Image = "\'All Departments\'", @String = "All Departments"]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |                 +- Expression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |                    +- PrimaryPrefix[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name", @SelfModifier = false]
                  |  |                       +- SimpleExpression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |                          +- Column[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |                             +- ID[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  +- ColumnAlias[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  |  +- ID[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |  +- SqlExpression[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "DECODE", @Image = "DECODE", @SelfModifier = false]
                  |  |     +- FunctionCall[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |        +- FunctionName[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |        |  +- ID[@CanonicalImage = "DECODE", @Image = "DECODE"]
                  |  |        +- Arguments[@ArgumentCount = 4, @CanonicalImage = null]
                  |  |           +- ArgumentList[@CanonicalImage = null]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |              |  +- Expression[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |     +- PrimaryPrefix[@CanonicalImage = "GROUPING", @Image = "GROUPING", @SelfModifier = false]
                  |  |              |        +- FunctionCall[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |           +- FunctionName[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |           |  +- ID[@CanonicalImage = "GROUPING", @Image = "GROUPING"]
                  |  |              |           +- Arguments[@ArgumentCount = 1, @CanonicalImage = null]
                  |  |              |              +- ArgumentList[@CanonicalImage = null]
                  |  |              |                 +- Argument[@CanonicalImage = null]
                  |  |              |                    +- Expression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |              |                       +- PrimaryPrefix[@CanonicalImage = "JOB_ID", @Image = "job_id", @SelfModifier = false]
                  |  |              |                          +- SimpleExpression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |              |                             +- Column[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |              |                                +- ID[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |              |  +- Expression[@CanonicalImage = "1", @Image = "1"]
                  |  |              |     +- PrimaryPrefix[@CanonicalImage = "1", @Image = "1", @SelfModifier = false]
                  |  |              |        +- Literal[@CanonicalImage = "1", @Image = "1"]
                  |  |              |           +- NumericLiteral[@CanonicalImage = "1", @Image = "1"]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |              |  +- Expression[@CanonicalImage = "\'ALL JOBS\'", @Image = "\'All Jobs\'"]
                  |  |              |     +- PrimaryPrefix[@CanonicalImage = "\'ALL JOBS\'", @Image = "\'All Jobs\'", @SelfModifier = false]
                  |  |              |        +- Literal[@CanonicalImage = "\'ALL JOBS\'", @Image = "\'All Jobs\'"]
                  |  |              |           +- StringLiteral[@CanonicalImage = "\'ALL JOBS\'", @Image = "\'All Jobs\'", @String = "All Jobs"]
                  |  |              +- Argument[@CanonicalImage = null]
                  |  |                 +- Expression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |                    +- PrimaryPrefix[@CanonicalImage = "JOB_ID", @Image = "job_id", @SelfModifier = false]
                  |  |                       +- SimpleExpression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |                          +- Column[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |                             +- ID[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  +- ColumnAlias[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  |  +- ID[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |  +- SqlExpression[@CanonicalImage = "COUNT", @Image = "count"]
                  |  |  +- PrimaryPrefix[@CanonicalImage = "COUNT", @Image = "count", @SelfModifier = false]
                  |  |     +- SimpleExpression[@CanonicalImage = "COUNT", @Image = "count"]
                  |  |        +- Column[@CanonicalImage = "COUNT", @Image = "count"]
                  |  |           +- ID[@CanonicalImage = "COUNT", @Image = "count"]
                  |  +- ColumnAlias[@CanonicalImage = "TOTAL_EMPL", @Image = "Total_Empl"]
                  |     +- ID[@CanonicalImage = "TOTAL_EMPL", @Image = "Total_Empl"]
                  +- IntoClause[@CanonicalImage = null]
                  |  +- VariableName[@CanonicalImage = "SOME_RECORD", @Image = "some_record"]
                  |     +- ID[@CanonicalImage = "SOME_RECORD", @Image = "some_record"]
                  +- FromClause[@CanonicalImage = null]
                  |  +- TableReference[@CanonicalImage = null]
                  |  |  +- TableName[@CanonicalImage = "EMPLOYEES", @Image = "employees"]
                  |  |  |  +- ID[@CanonicalImage = "EMPLOYEES", @Image = "employees"]
                  |  |  +- TableAlias[@CanonicalImage = "E", @Image = "e"]
                  |  |     +- ID[@CanonicalImage = "E", @Image = "e"]
                  |  +- TableReference[@CanonicalImage = null]
                  |     +- TableName[@CanonicalImage = "DEPARTMENTS", @Image = "departments"]
                  |     |  +- ID[@CanonicalImage = "DEPARTMENTS", @Image = "departments"]
                  |     +- TableAlias[@CanonicalImage = "D", @Image = "d"]
                  |        +- ID[@CanonicalImage = "D", @Image = "d"]
                  +- WhereClause[@CanonicalImage = null]
                  |  +- Condition[@CanonicalImage = null]
                  |     +- CompoundCondition[@CanonicalImage = null, @Type = null]
                  |        +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
                  |           +- SqlExpression[@CanonicalImage = "D.DEPARTMENT_ID", @Image = "d.department_id"]
                  |           |  +- PrimaryPrefix[@CanonicalImage = "D.DEPARTMENT_ID", @Image = "d.department_id", @SelfModifier = false]
                  |           |     +- SimpleExpression[@CanonicalImage = "D.DEPARTMENT_ID", @Image = "d.department_id"]
                  |           |        +- TableName[@CanonicalImage = "D", @Image = "d"]
                  |           |        |  +- ID[@CanonicalImage = "D", @Image = "d"]
                  |           |        +- Column[@CanonicalImage = "DEPARTMENT_ID", @Image = "department_id"]
                  |           |           +- ID[@CanonicalImage = "DEPARTMENT_ID", @Image = "department_id"]
                  |           +- SqlExpression[@CanonicalImage = "E.DEPARTMENT_ID", @Image = "e.department_id"]
                  |              +- PrimaryPrefix[@CanonicalImage = "E.DEPARTMENT_ID", @Image = "e.department_id", @SelfModifier = false]
                  |                 +- SimpleExpression[@CanonicalImage = "E.DEPARTMENT_ID", @Image = "e.department_id"]
                  |                    +- TableName[@CanonicalImage = "E", @Image = "e"]
                  |                    |  +- ID[@CanonicalImage = "E", @Image = "e"]
                  |                    +- Column[@CanonicalImage = "DEPARTMENT_ID", @Image = "department_id"]
                  |                       +- ID[@CanonicalImage = "DEPARTMENT_ID", @Image = "department_id"]
                  +- GroupByClause[@CanonicalImage = null]
                  |  +- RollupCubeClause[@CanonicalImage = "CUBE", @Image = "CUBE"]
                  |     +- GroupingExpressionList[@CanonicalImage = null]
                  |        +- ExpressionList[@CanonicalImage = null]
                  |           +- ExpressionListSingle[@CanonicalImage = null]
                  |              +- SqlExpression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |              |  +- PrimaryPrefix[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name", @SelfModifier = false]
                  |              |     +- SimpleExpression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |              |        +- Column[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |              |           +- ID[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                  |              +- SqlExpression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |                 +- PrimaryPrefix[@CanonicalImage = "JOB_ID", @Image = "job_id", @SelfModifier = false]
                  |                    +- SimpleExpression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |                       +- Column[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  |                          +- ID[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                  +- OrderByClause[@CanonicalImage = null]
                     +- SqlExpression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                     |  +- PrimaryPrefix[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name", @SelfModifier = false]
                     |     +- SimpleExpression[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                     |        +- Column[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                     |           +- ID[@CanonicalImage = "DEPARTMENT_NAME", @Image = "department_name"]
                     +- SqlExpression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                        +- PrimaryPrefix[@CanonicalImage = "JOB_ID", @Image = "job_id", @SelfModifier = false]
                           +- SimpleExpression[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                              +- Column[@CanonicalImage = "JOB_ID", @Image = "job_id"]
                                 +- ID[@CanonicalImage = "JOB_ID", @Image = "job_id"]
