 |
398 |
484 |
546 |
578 |
586 |
47.24% |
63 |
62 |
72 |
48 |
45 |
-28.57% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '1'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
222 |
216 |
228 |
235 |
204 |
-8.11% |
113 |
109 |
125 |
136 |
139 |
23.01% |
1,055 |
1,084 |
1,175 |
1,342 |
27.2% |
7,064 |
6,764 |
7,115 |
6,560 |
-7.13% |
0 |
202 |
 |
431 |
458 |
591 |
576 |
583 |
35.27% |
72 |
54 |
69 |
31 |
45 |
-37.5% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '2'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
362 |
382 |
355 |
338 |
295 |
-18.51% |
122 |
142 |
167 |
149 |
141 |
15.57% |
700 |
786 |
910 |
1,109 |
58.43% |
3,961 |
3,877 |
4,672 |
4,447 |
12.27% |
5 |
209 |
 |
1,630 |
1,823 |
2,311 |
2,363 |
2,339 |
43.5% |
118 |
157 |
127 |
120 |
111 |
-5.93% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '3'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
2,325 |
2,500 |
2,550 |
2,575 |
2,257 |
-2.92% |
1,323 |
1,456 |
2,486 |
1,534 |
1,418 |
7.18% |
2,397 |
2,352 |
2,434 |
2,571 |
7.26% |
14,693 |
14,004 |
14,515 |
13,372 |
-8.99% |
68 |
732 |
 |
539 |
504 |
619 |
609 |
604 |
12.06% |
278 |
256 |
217 |
241 |
219 |
-21.22% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '4'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
3,006 |
3,011 |
3,057 |
3,100 |
3,013 |
0.23% |
459 |
499 |
588 |
482 |
463 |
0.87% |
2,836 |
2,849 |
3,011 |
3,220 |
13.54% |
12,902 |
12,743 |
13,329 |
12,449 |
-3.51% |
0 |
2,105 |
 |
303 |
294 |
338 |
346 |
406 |
33.99% |
175 |
193 |
195 |
241 |
171 |
-2.29% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '5'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
21 |
32 |
74 |
104 |
111 |
428.57% |
64 |
79 |
94 |
81 |
71 |
10.94% |
1,787 |
1,733 |
1,814 |
1,909 |
6.83% |
11,004 |
10,733 |
10,800 |
10,149 |
-7.77% |
0 |
273 |
 |
382 |
420 |
478 |
495 |
495 |
29.58% |
100 |
57 |
58 |
43 |
32 |
-68% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '6'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
153 |
157 |
175 |
161 |
153 |
0% |
126 |
113 |
148 |
140 |
121 |
-3.97% |
1,213 |
1,256 |
1,400 |
1,712 |
41.14% |
5,444 |
5,442 |
6,239 |
5,468 |
0.44% |
10 |
284 |
 |
227 |
217 |
276 |
297 |
326 |
43.61% |
81 |
115 |
90 |
86 |
73 |
-9.88% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '7'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
1,551 |
1,558 |
1,581 |
1,535 |
1,580 |
1.87% |
95 |
116 |
399 |
101 |
90 |
-5.26% |
2,443 |
2,549 |
2,725 |
3,116 |
27.55% |
9,611 |
9,553 |
10,123 |
9,147 |
-4.83% |
19 |
694 |
 |
219 |
241 |
296 |
304 |
339 |
54.79% |
79 |
122 |
110 |
100 |
88 |
11.39% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '8'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
5,716 |
7,138 |
7,363 |
7,008 |
5,764 |
0.84% |
337 |
325 |
393 |
317 |
293 |
-13.06% |
460 |
407 |
601 |
729 |
58.48% |
3,689 |
3,473 |
3,649 |
3,396 |
-7.94% |
1 |
862 |
 |
382 |
327 |
402 |
454 |
428 |
12.04% |
55 |
56 |
67 |
61 |
29 |
-47.27% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '9'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
122 |
123 |
128 |
136 |
135 |
10.66% |
24 |
26 |
18 |
20 |
34 |
41.67% |
1,788 |
1,847 |
2,070 |
2,413 |
34.96% |
5,786 |
6,006 |
6,263 |
5,786 |
0% |
122 |
406 |
 |
348 |
389 |
442 |
426 |
436 |
25.29% |
66 |
50 |
50 |
71 |
35 |
-46.97% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '10'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
13 |
20 |
36 |
32 |
27 |
107.69% |
59 |
41 |
55 |
45 |
46 |
-22.03% |
2,563 |
2,569 |
2,613 |
2,785 |
8.66% |
15,297 |
14,729 |
15,173 |
13,963 |
-8.72% |
3 |
79 |
 |
1,106 |
1,215 |
1,323 |
1,396 |
1,356 |
22.6% |
179 |
194 |
210 |
151 |
173 |
-3.35% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '11'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
269 |
281 |
353 |
292 |
279 |
3.72% |
427 |
523 |
577 |
660 |
629 |
47.31% |
1,667 |
1,713 |
1,926 |
2,240 |
34.37% |
5,318 |
5,557 |
5,750 |
5,333 |
0.28% |
1 |
1,133 |
 |
225 |
250 |
292 |
352 |
345 |
53.33% |
58 |
79 |
68 |
80 |
55 |
-5.17% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '12'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
71 |
82 |
109 |
109 |
113 |
59.15% |
60 |
56 |
62 |
66 |
68 |
13.33% |
2,555 |
2,524 |
2,659 |
2,941 |
15.11% |
13,073 |
12,682 |
13,639 |
12,280 |
-6.07% |
14 |
200 |
 |
432 |
456 |
516 |
629 |
584 |
35.19% |
114 |
114 |
93 |
122 |
94 |
-17.54% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '13'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
132 |
161 |
202 |
180 |
189 |
43.18% |
60 |
49 |
72 |
81 |
67 |
11.67% |
1,900 |
1,822 |
2,004 |
2,238 |
17.79% |
9,248 |
9,135 |
9,779 |
8,919 |
-3.56% |
5 |
538 |
 |
486 |
512 |
575 |
641 |
616 |
26.75% |
39 |
54 |
59 |
36 |
40 |
2.56% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '14'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
47 |
45 |
70 |
58 |
49 |
4.26% |
35 |
37 |
114 |
32 |
43 |
22.86% |
513 |
471 |
710 |
968 |
88.69% |
1,483 |
1,619 |
2,234 |
1,969 |
32.77% |
4 |
199 |
 |
840 |
864 |
980 |
1,102 |
1,173 |
39.64% |
135 |
94 |
105 |
73 |
118 |
-12.59% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '15'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
315 |
309 |
425 |
453 |
418 |
32.7% |
182 |
178 |
275 |
162 |
162 |
-10.99% |
1,213 |
1,256 |
1,400 |
1,712 |
41.14% |
5,444 |
5,442 |
6,239 |
5,468 |
0.44% |
9 |
401 |
 |
83 |
61 |
61 |
73 |
97 |
16.87% |
108 |
78 |
61 |
105 |
57 |
-47.22% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '16'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
86 |
101 |
98 |
98 |
112 |
30.23% |
66 |
52 |
115 |
76 |
77 |
16.67% |
1,387 |
1,352 |
1,514 |
1,635 |
17.88% |
7,765 |
7,570 |
8,212 |
7,898 |
1.71% |
0 |
88 |
 |
21 |
20 |
27 |
22 |
19 |
-9.52% |
1 |
5 |
6 |
3 |
1 |
0% |
®ERROR:SQLSTATE[HY000]: General error: 20018 The column 'anio2023' was specified multiple times for 'tabla'. [20018] (severity 16) [WITH tabla AS
(
SELECT
TituloProyecto,
AreaConocimiento,
TipoFinanciamiento,
TipoProyecto,
TemaProyecto,
FechaInicio AS inicio,
FechaFin AS fin,
CASE WHEN 2015 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2015,
CASE WHEN 2016 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2016,
CASE WHEN 2017 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2017,
CASE WHEN 2018 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2018,
CASE WHEN 2019 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2019,
CASE WHEN 2020 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2020,
CASE WHEN 2021 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2021,
CASE WHEN 2022 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023,
CASE WHEN 2023 BETWEEN FechaInicio AND FechaFin THEN 1 ELSE 0 END AS anio2023
FROM UNAM_DGEI_DB.dbo.Proyectos
JOIN Sostenibilidad.dbo.Proyectos_ODS
ON Proyectos.ClaveProyectoPresupuesto = Proyectos_ODS.ClaveProyectoPresupuesto
WHERE ODS = '17'
)
SELECT
SUM(anio2015) AS total2015,
SUM(anio2016) AS total2016,
SUM(anio2017) AS total2017,
SUM(anio2018) AS total2018,
SUM(anio2019) AS total2019,
SUM(anio2020) AS total2020,
SUM(anio2021) AS total2021,
SUM(anio2022) AS total2022
FROM tabla]
0 |
0 |
0 |
0 |
0 |
- |
0 |
0 |
0 |
0 |
0 |
- |
7 |
2 |
7 |
6 |
3 |
-57.14% |
518 |
566 |
894 |
1,132 |
118.53% |
4,671 |
4,686 |
5,875 |
6,566 |
40.57% |
0 |
16 |
Totales |
4,324 |
4,623 |
5,408 |
5,642 |
5,790 |
33.9% |
1,720 |
1,736 |
1,656 |
1,615 |
1,388 |
-19.3% |
563 |
976 |
1,573 |
2,265 |
2,218 |
293.96% |
13,906 |
15,567 |
16,104 |
15,735 |
14,036 |
0.93% |
3,091 |
3,298 |
4,857 |
3,503 |
3,331 |
7.76% |
26,995 |
27,136 |
29,860 |
33,772 |
25.1% |
136,453 |
134,015 |
143,606 |
133,170 |
-2.41% |
233 |
5,524 |