ERROR EN SINTAXIS SQL BIGQUERY
Publicado por MIRUS (1 intervención) el 23/01/2020 05:19:35
TENGO ESTE CÓDIGO QUIERO ANEXAR LA VARIABLE EN CIRCULO DE LA IMAGEN...NO ME SALEEE EN QUE PARTE LE DEBO ANEXAR
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
select total.*,
total.q1 + total.q2 as total_dias
from
(select resumen.* ,
case
WHEN resumen.mes = 202001 THEN 11
WHEN resumen.mes = 202002 THEN 10.5
WHEN resumen.mes = 202003 THEN 11
WHEN resumen.mes = 202004 THEN 9.5
WHEN resumen.mes = 202005 THEN 11
WHEN resumen.mes = 202006 THEN 12
WHEN resumen.mes = 202007 THEN 12
WHEN resumen.mes = 202008 THEN 11.5
WHEN resumen.mes = 202009 THEN 12
WHEN resumen.mes = 202010 THEN 12
WHEN resumen.mes = 202011 THEN 10
WHEN resumen.mes = 202012 THEN 11.5
end as q1,case
WHEN resumen.mes = 202001 THEN 13
WHEN resumen.mes = 202002 THEN 11
WHEN resumen.mes = 202003 THEN 12
WHEN resumen.mes = 202004 THEN 12
WHEN resumen.mes = 202005 THEN 11.5
WHEN resumen.mes = 202006 THEN 12
WHEN resumen.mes = 202007 THEN 13
WHEN resumen.mes = 202008 THEN 12
WHEN resumen.mes = 202009 THEN 11
WHEN resumen.mes = 202010 THEN 12.5
WHEN resumen.mes = 202011 THEN 11
WHEN resumen.mes = 202012 THEN 12
end as q2
from
(select info.mes, info.sucursal, sum( total_monto_N) as monto_meta, sum( total_monto_R) AS monto_R, SUM (monto_revolvencia) as monto_revolvencia
FROM
(select datos.mes, datos.sucursal,
case
WHEN datos.tipo_credito= 'N' THEN datos.monto_meta
else 0
end as total_monto_N,case
WHEN datos.tipo_credito= 'R' THEN datos.monto_meta
else 0
end AS total_monto_R,datos.monto_revolvenciaFROM
(select mv.mes, mv.sucursal, mv.tipo_credito, sum(mv.monto_meta) as monto_meta, sum(mv.monto_revolvencia) as monto_revolvencia
from BUO_FISA.metas_ventas as mvWHERE mv.mes = 202001 and mv.grupo = 50
--and mv.sucursal = 10
group by mv.mes, mv.sucursal, mv.tipo_credito
) as datos) AS infogroup by info.mes, info.sucursal
) as resumen) totalorder by sucursal
Valora esta pregunta
0
