[
    ~[tlist_sql;
        SELECT * FROM (
            SELECT
                STUDENTS.DCID,
                STUDENTS.STUDENT_NUMBER,
                STUDENTS.LASTFIRST,
                STUDENTS.GRADE_LEVEL,
                STUDENTS.SCHED_NEXTYEARGRADE,
                SCHOOLS.NAME AS NEXT_SCHOOL_NAME,
                SCHOOLS.LOW_GRADE || '-' || SCHOOLS.HIGH_GRADE AS SCHOOL_GRADE_RANGE,
                CASE WHEN SCHOOLS.NAME IS NOT NULL THEN 1 ELSE 0 END AS VALID_NEXT_SCHOOL,
                CASE WHEN STUDENTS.SCHED_NEXTYEARGRADE 
                    BETWEEN SCHOOLS.LOW_GRADE AND SCHOOLS.HIGH_GRADE THEN 1 
                    WHEN STUDENTS.SCHED_NEXTYEARGRADE = 99
                        AND SCHOOLS.NAME = 'Graduated Students' THEN 1 
                    ELSE 0 
                END AS VALID_NEXT_GRADE
            FROM PS.STUDENTS
            LEFT JOIN PS.SCHOOLS ON SCHOOLS.SCHOOL_NUMBER = STUDENTS.NEXT_SCHOOL
            WHERE STUDENTS.ENROLL_STATUS IN (-1,0)
                AND STUDENTS.SCHOOLID = ~(curschoolid)
            ORDER BY STUDENTS.LASTFIRST DESC
        ) WHERE VALID_NEXT_SCHOOL <> 1 OR VALID_NEXT_GRADE <> 1
    ;]
        {
            "student_dcid":             "~(DCID;JSON)",
            "student_number":           "~(STUDENT_NUMBER;JSON)",
            "student_lastfirst":        "~(LASTFIRST;JSON)",
            "student_grade_level":      "~(GRADE_LEVEL;JSON)",
            "student_next_grade_level": "~(SCHED_NEXTYEARGRADE;JSON)",
            "next_school_name":         "~(NEXT_SCHOOL_NAME;JSON)",
            "next_school_grade_range":  "~(SCHOOL_GRADE_RANGE;JSON)",
            "valid_next_school":        "~(VALID_NEXT_SCHOOL;JSON)",
            "valid_next_grade":         "~(VALID_NEXT_GRADE;JSON)"            
        },
    [/tlist_sql]
    {}
]