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

institutionPROUNI.sql

Blame
  • institutionPROUNI.sql 1.18 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 institution_prouni_ag 
    AS 
    SELECT 
        prouni_temp.ano_censo, 
        prouni_temp.nome_ies 
    
    FROM 
        (
            SELECT 
                distinct(nome_ies), 
                ano_censo 
            FROM 
                fies
        ) AS prouni_temp 
    
    GROUP BY 
        prouni_temp.ano_censo, 
        prouni_temp.nome_ies 
    
    ORDER BY
        prouni_temp.ano_censo ASC, 
        prouni_temp.nome_ies ASC
    ;