Skip to content
Snippets Groups Projects
Select Git revision
  • simcaq-new-tables
  • docente-type-2-test
  • development default protected
  • issue-811-region
  • add_filters_localoferta_matricula
  • postgres
  • issue-752-aee
  • homologa protected
  • master protected
9 results

prouni.sql

Blame
  • prouni.sql 1.67 KiB
    --
    --Copyright (C) 2019 Centro de Computacao Cientifica e Software Livre
    --Departamento de Informatica - Universidade Federal do Parana - C3SL/UFPR
    --
    --This file is part of SMPPIR-Tables.
    --
    --SMPPIR-Tables is free software: you can redistribute it and/or modify
    --it under the terms of the GNU General Public License as published by
    --the Free Software Foundation, either version 3 of the License, or
    --(at your option) any later version.
    --
    --SMPPIR-Tables is distributed in the hope that it will be useful,
    --but WITHOUT ANY WARRANTY; without even the implied warranty of
    --MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    --GNU General Public License for more details.
    --
    --You should have received a copy of the GNU General Public License
    --along with SMPPIR-Tables.  If not, see <https://www.gnu.org/licenses/>.
    --
    
    CREATE TABLE prouni_ag 
    AS 
    SELECT 
        prouni.genero_beneficiario,
        prouni.raca_beneficiario,
        prouni.nome_curso,
        prouni.nome_ies,
        prouni.tipo,
        prouni.sigla_uf_beneficiario,
        prouni.regiao_beneficiario,
        prouni.ano_censo,
        prouni.nome_turno_curso,
        COUNT(*) AS total 
    
    FROM 
        prouni 
    
    GROUP BY 
        prouni.genero_beneficiario, 
        prouni.raca_beneficiario, 
        prouni.nome_curso, 
        prouni.nome_ies, 
        prouni.tipo, 
        prouni.sigla_uf_beneficiario, 
        prouni.regiao_beneficiario, 
        prouni.nome_turno_curso,
        prouni.ano_censo
    
    ORDER BY 
        prouni.genero_beneficiario ASC, 
        prouni.raca_beneficiario ASC, 
        prouni.nome_curso ASC, 
        prouni.nome_ies ASC, 
        prouni.tipo ASC, 
        prouni.sigla_uf_beneficiario ASC, 
        prouni.regiao_beneficiario ASC, 
        prouni.nome_turno_curso ASC,
        prouni.ano_censo ASC
    ;