The avatar for @elaval
Ernesto Laval
Public
Edited
Oct 27, 2024
2
Insert cell
Insert cell
Insert cell
20230906_Matrícula_unica_2023_20230430_WEB.parquet
SELECT COD_REG_RBD,NOM_REG_RBD_A,NOM_DEPROV_RBD,
count(*) as matriculaTotal,
SUM(CASE WHEN COD_ENSE3 = 1 THEN 1 ELSE 0 END)::Int as "matriculaParvularia",
SUM(CASE WHEN COD_ENSE3 = 2 THEN 1 ELSE 0 END)::Int as "matriculaBasicaNiños",
SUM(CASE WHEN COD_ENSE3 = 3 THEN 1 ELSE 0 END)::Int as "matriculaBasicaAdultos",
SUM(CASE WHEN COD_ENSE3 = 4 THEN 1 ELSE 0 END)::Int as "matriculaMediaHCJovenes",
SUM(CASE WHEN COD_ENSE3 = 5 THEN 1 ELSE 0 END)::Int as "matriculaMediaHCJAdultos",
SUM(CASE WHEN COD_ENSE3 = 6 THEN 1 ELSE 0 END)::Int as "matriculaMediaTPJovenes",
SUM(CASE WHEN COD_ENSE3 = 7 THEN 1 ELSE 0 END)::Int as "matriculaMediaTPJAdultos",
FROM "20230906_Matrícula_unica_2023_20230430_WEB"
GROUP BY COD_REG_RBD,NOM_REG_RBD_A, NOM_DEPROV_RBD
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more