[
    ~[tlist_sql;
        WITH SCHOOL_GRADE_LEVELS AS (
            SELECT
                GRADE_LEVELS.GRADE_LEVEL,
                SCHOOLS.SCHOOL_NUMBER
            FROM PS.SCHOOLS
            JOIN ( SELECT (ROWNUM - 2) GRADE_LEVEL FROM DUAL CONNECT BY LEVEL <= 102 ) GRADE_LEVELS ON 
                GRADE_LEVELS.GRADE_LEVEL BETWEEN PS.SCHOOLS.LOW_GRADE AND PS.SCHOOLS.HIGH_GRADE
            WHERE SCHOOL_NUMBER = ~(curschoolid)
        )
        SELECT
            SCHOOL_GRADE_LEVELS.GRADE_LEVEL,
            SUM(CASE WHEN FTE_GRADE.DCID IS NOT NULL THEN 1 ELSE 0 END) AS HAS_FTE
        FROM SCHOOL_GRADE_LEVELS
        LEFT JOIN PS.FTE ON PS.FTE.SCHOOLID = SCHOOL_GRADE_LEVELS.SCHOOL_NUMBER AND FTE.YEARID = ~(curyearid)
        LEFT JOIN PS.FTE_GRADE ON FTE_GRADE.FTEID = FTE.ID AND FTE_GRADE.GRADE_LEVEL = SCHOOL_GRADE_LEVELS.GRADE_LEVEL
        GROUP BY SCHOOL_GRADE_LEVELS.GRADE_LEVEL
        ORDER BY SCHOOL_GRADE_LEVELS.GRADE_LEVEL DESC
    ;]
        {
            "grade_level":          "~(GRADE_LEVEL;JSON)",
            "has_fte":              "~(HAS_FTE;JSON)"
        },
    [/tlist_sql]
    {}
]