CREATE OR REPLACE VIEW relatorio.view_historico_9anos_extra_curricular AS
SELECT
    historico_disciplinas.ref_ref_cod_aluno AS cod_aluno,
    historico_disciplinas.nm_disciplina AS disciplina,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 1::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_1serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 2::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_2serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 3::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_3serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 4::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_4serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 5::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_5serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 6::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_6serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 7::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_7serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 8::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_8serie,
    (
        SELECT
            CASE
                WHEN "substring"(btrim(hd.nota::text), 1, 1) <> 0::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 1::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 2::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 3::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 4::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 5::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 6::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 7::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 8::text
                    AND "substring"(btrim(hd.nota::text), 1, 1) <> 9::text
                    THEN replace(hd.nota::text, '.'::text, ','::text)
                WHEN to_number(btrim(hd.nota::text), '999'::text) > 10::numeric
                    AND to_number(btrim(hd.nota::text), '999'::text) <= 20::numeric
                    THEN replace(btrim(hd.nota::text), '.'::text, ','::text)
                ELSE replace("substring"(btrim(hd.nota::text), 1, 4), '.'::text, ','::text)
            END AS replace
        FROM pmieducar.historico_disciplinas hd
            JOIN pmieducar.historico_escolar historico_escolar_1 ON true
                AND historico_escolar_1.ref_cod_aluno = hd.ref_ref_cod_aluno
                AND historico_escolar_1.sequencial = hd.ref_sequencial
        WHERE true
            AND hd.ref_ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND fcn_upper(hd.nm_disciplina::text) = fcn_upper(historico_disciplinas.nm_disciplina::text)
            AND historico_escolar_1.ativo = 1
            AND historico_escolar_1.extra_curricular = 1
            AND historico_escolar_1.ano = (
                (
                    SELECT he.ano
                    FROM pmieducar.historico_escolar he
                    WHERE true
                        AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he.ativo = 1
                        AND he.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he.ref_cod_aluno
                                    AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he.nm_serie::text, 1, 1) = 9::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS nota_9serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 1::text
        LIMIT 1
    ) AS ano_1serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 2::text
        LIMIT 1
    ) AS ano_2serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 3::text
        LIMIT 1
    ) AS ano_3serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 4::text
        LIMIT 1
    ) AS ano_4serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 5::text
        LIMIT 1
    ) AS ano_5serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 6::text
        LIMIT 1
    ) AS ano_6serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 7::text
        LIMIT 1
    ) AS ano_7serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 8::text
        LIMIT 1
    ) AS ano_8serie,
    (
        SELECT he.ano
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.sequencial = (
                (
                    SELECT max(hee.sequencial) AS max
                    FROM pmieducar.historico_escolar hee
                    WHERE true
                        AND hee.ref_cod_aluno = he.ref_cod_aluno
                        AND "substring"(he.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                        AND hee.ativo = 1
                        AND hee.extra_curricular = 0
                )
            )
            AND "substring"(he.nm_serie::text, 1, 1) = 9::text
        LIMIT 1
    ) AS ano_9serie,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 1::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido1,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 2::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido2,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 3::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido3,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 4::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido4,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 5::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido5,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 6::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido6,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 7::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido7,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 8::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido8,
    (
        SELECT DISTINCT he.aprovado = 4
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 9::text
                    LIMIT 1
                )
            )
        ORDER BY (he.aprovado = 4)
        LIMIT 1
    ) AS transferido9,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 1::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria1,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 2::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria2,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 3::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria3,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 4::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria4,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 5::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria5,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 6::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria6,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 7::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria7,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 8::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria8,
    (
        SELECT he.carga_horaria
        FROM pmieducar.historico_escolar he
        WHERE true
            AND he.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
            AND he.ativo = 1
            AND he.extra_curricular = 1
            AND he.ano = (
                (
                    SELECT he_1.ano
                    FROM pmieducar.historico_escolar he_1
                    WHERE true
                        AND he_1.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
                        AND he_1.ativo = 1
                        AND he_1.sequencial = (
                            (
                                SELECT max(hee.sequencial) AS max
                                FROM pmieducar.historico_escolar hee
                                WHERE true
                                    AND hee.ref_cod_aluno = he_1.ref_cod_aluno
                                    AND "substring"(he_1.nm_serie::text, 1, 1) = "substring"(hee.nm_serie::text, 1, 1)
                                    AND hee.ativo = 1
                                    AND hee.extra_curricular = 0
                            )
                        )
                        AND "substring"(he_1.nm_serie::text, 1, 1) = 9::text
                    LIMIT 1
                )
            )
        LIMIT 1
    ) AS carga_horaria9
FROM (
    SELECT
        historico_escolar.ref_cod_aluno,
        (fcn_upper(historico_disciplinas.nm_disciplina::text)) AS nm_disciplina,
        historico_escolar.sequencial,
        historico_disciplinas.ref_sequencial,
        historico_disciplinas.ref_ref_cod_aluno,
        historico_escolar.extra_curricular,
        historico_escolar.ativo
    FROM pmieducar.historico_disciplinas
    JOIN pmieducar.historico_escolar ON true
        AND historico_escolar.ref_cod_aluno = historico_disciplinas.ref_ref_cod_aluno
        AND historico_escolar.sequencial = historico_disciplinas.ref_sequencial
) historico_disciplinas
WHERE true
    AND historico_disciplinas.extra_curricular = 1
    AND historico_disciplinas.ativo = 1
GROUP BY
    historico_disciplinas.nm_disciplina,
    historico_disciplinas.ref_cod_aluno,
    historico_disciplinas.ref_ref_cod_aluno
ORDER BY historico_disciplinas.nm_disciplina;