Add region in institution

institution.sql

@@ -18,13 +18,14 @@
 --along with SMPPIR-Tables.  If not, see <https://www.gnu.org/licenses/>.
 --
 
-CREATE TABLE institution_ag 
+CREATE TABLE institution_ag
 AS 
 SELECT 
     inst.ano_censo, 
     nome_ies, 
     cod_ies,
-    sigla_uf_ies
+    sigla_uf_ies,
+    CASE WHEN ("cod_uf_ies"= 11 OR "cod_uf_ies"=12 OR "cod_uf_ies"=13 OR "cod_uf_ies"=14 OR "cod_uf_ies"=15 OR "cod_uf_ies"=16 OR "cod_uf_ies"=17) THEN 'Norte' WHEN ("cod_uf_ies"= 21 OR "cod_uf_ies"=22 OR "cod_uf_ies"=23 OR "cod_uf_ies"=24 OR "cod_uf_ies"=25 OR "cod_uf_ies"=26 OR "cod_uf_ies"=27 OR "cod_uf_ies"=28 OR "cod_uf_ies"=29)  THEN 'Nordeste' WHEN ("cod_uf_ies"= 31 OR "cod_uf_ies"=32 OR "cod_uf_ies"=33 OR "cod_uf_ies"=35)  THEN 'Sudeste' WHEN ("cod_uf_ies"= 41 OR "cod_uf_ies"=42 OR "cod_uf_ies"=43)  THEN 'Sul' WHEN ("cod_uf_ies"= 50 OR "cod_uf_ies"=51 OR "cod_uf_ies"=52 OR "cod_uf_ies"=53)  THEN 'Centro-Oeste' ELSE null END AS region
     
 FROM 
     ies_ens_superior as inst 
@@ -43,10 +44,12 @@ GROUP BY
     inst.ano_censo, 
     nome_ies, 
     cod_ies,
-    sigla_uf_ies
+    sigla_uf_ies,
+    region
 
 ORDER BY 
     inst.ano_censo ASC, 
     nome_ies ASC,
-    sigla_uf_ies
+    sigla_uf_ies,
+    region
 ;
\ No newline at end of file