select aa.cd_perd_letv, o.nm_org, cc.NM_IDENT_COMPNT_CURR, cc.NM_COMPNT_CURR, t.NM_IDENT_TURMA, count(*)
  from siga_matricula_turma mt,
       siga_turma t,
       siga_atividade_academica aa,
       siga_componente_curricular cc,
       siga_orgao o
 where mt.cd_turma=t.cd_turma
   and t.cd_ativ_acad=aa.cd_ativ_acad
   and aa.cd_compnt_curr=cc.cd_compnt_curr
   and aa.cd_org=o.cd_org   
   and mt.nu_sit_matr_turma=1
   and o.cd_tp_org not in (42) -- Apenas Graduação
   and aa.cd_perd_letv in ('2014.2') -- Alterar Ano base
group by aa.cd_perd_letv, o.nm_org, cc.NM_IDENT_COMPNT_CURR, cc.NM_COMPNT_CURR, t.NM_IDENT_TURMA having count(*) < 5 -- Alterar quantidade mínima
order by aa.cd_perd_letv, o.nm_org, cc.NM_COMPNT_CURR