CREATE TABLE institution_private_ag 
AS 
SELECT 
    inst.ano_censo, 
    nome_ies, 
    cod_ies 
FROM 
    ies_ens_superior as inst 

WHERE 
    (ano_censo = 
        (
            SELECT 
                MAX(ano_censo) 
            FROM 
                ies_ens_superior as ies 
            WHERE 
                inst.cod_ies = ies.cod_ies
        )
    ) 

GROUP BY 
    inst.ano_censo, 
    nome_ies, 
    cod_ies 

ORDER BY 
    inst.ano_censo ASC, 
    nome_ies ASC
    ;