HTML |
---|
<center><font size="5000"> MELHORAR A QUALIDADE DOS DADOS EM 70% </font></center> |
chart
SQL |
---|
|
|
|
|
0 | 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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Meta | 1640 | 1600 | 1560 | 1520 | 1480 | 1440 | 1400 | 1360 | 1320 | 1280 | 1240 | 1200 | 1160 | 1120 | 1080 | 1040 | 1000 | 960 | 920 | 880 | 840 | 800 | 760 | 720 | 680 | 640 |
Real |
| ||
select 'ANTES' AS Tipo,
sum(totalErros) as Reg,
sum(tipoErros) as Itens,
count(*) as Tot
from
(
select nuSerie, sum(qtd) as totalErros, count(*) as tipoErros
from esanTesteAuditorErroInicio
where tipoValidacao = 'V'
group by nuSerie
)
union
select 'DEPOIS' as Tipo,
sum(totalErros) as Reg,
sum(tipoErros) as Itens,
count(*) as Tot
from
(
select nuSerie, sum(qtd) as totalErros, count(*) as tipoErros
from esanTesteFirebirdErro
where tipoValidacao = 'V'
group by nuSerie
)
|