Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 'Positivação' as SERIE, ANO AS X, clientes_positivados as Y FROM (
- SELECT EXTRACT(year FROM pcmov.DTMOV) AS ANO, COUNT(DISTINCT pcclient.codcli) clientes_positivados
- FROM pcnfsaid,
- pcmov,
- pcclient
- WHERE pcnfsaid.numtransvenda = pcmov.numtransvenda
- AND pcnfsaid.dtcancel IS NULL
- AND pcclient.codcli = pcmov.codprod
- AND pcclient.dtexclusao IS NULL
- AND nvl(pcnfsaid.tipovenda, 'X') NOT IN ('SR', 'DF')
- GROUP BY EXTRACT(year FROM pcmov.DTMOV)
- ) Q
- UNION
- SELECT 'TESTE' as SERIE, 2013 AS X, 50 AS Y FROM DUAL
- UNION
- SELECT 'TESTE' as SERIE, 2014 AS X, 60 AS Y FROM DUAL
- UNION
- SELECT 'TESTE' as SERIE, 2015 AS X, 70 AS Y FROM DUAL
- UNION
- SELECT 'TESTE' as SERIE, 2016 AS X, 80 AS Y FROM DUAL
- UNION
- SELECT 'TESTE' as SERIE, 2017 AS X, 50 AS Y FROM DUAL
- UNION
- SELECT 'TESTE' as SERIE, 2018 AS X, 60 AS Y FROM DUAL
- UNION
- SELECT 'TESTE' as SERIE, 2019 AS X, 70 AS Y FROM DUAL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement