SELECT
    CASE sp.nm_cor_raca
        WHEN '1'  THEN
            'Branca'
        WHEN '2'  THEN
            'Preta'
        WHEN '3'  THEN
            'Parda'
        WHEN '4'  THEN
            'Amarela'
        WHEN '5'  THEN
            'Indígena'
        WHEN '7'  THEN
            'Não Declarado'
    END AS cor_raca,
    COUNT(DISTINCT sp.nm_cpf_pess) AS total
FROM
    siga_pessoa             sp,
    siga_vinculo            v,
    siga_programa_formacao  pf
WHERE
        sp.nm_cpf_pess = v.nm_cpf_pess
    AND EXISTS (
        SELECT
            *
        FROM
            siga_turma                st,
            siga_atividade_academica  aa,
            siga_matricula_turma      mt
        WHERE
                st.cd_ativ_acad = aa.cd_ativ_acad
            AND st.cd_turma = mt.cd_turma
            AND mt.nu_matr_curso = v.nu_matr_curso
            AND mt.nu_sit_matr_turma = 1
            AND aa.cd_perd_letv = '2020.1'
    )
    AND pf.cd_progr_form = v.cd_progr_form
    AND pf.cd_nivel = 1
    AND pf.nm_progr_form LIKE '%UAG%'
GROUP BY
    sp.nm_cor_raca
ORDER BY
    total DESC;