SELECT   COUNT(sp.nm_cpf_pess) as total ,
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'
end as Cor_Raca FROM siga_pessoa sp, siga_vinculo v, SIGA_PROGRAMA_FORMACAO pf where sp.NM_COR_RACA in (1,2,3,4,5)
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 = '2017.2'
)
and sp.NM_CPF_PESS = v.nm_cpf_pess and
pf.CD_PROGR_FORM = v.CD_PROGR_FORM and
pf.CD_NIVEL = 1
GROUP BY sp.NM_COR_RACA order by Cor_Raca;