How to group ORACLE consultation?

0

I have the following query but the result that throws me is not the indicated

SELECT R1.SUBMISSION_TIME, A.TOTAL_MT, B.TOTAL_EXITO_MT_VAS FROM VAS.SMS_DATA_SMC R1
INNER JOIN
(
    SELECT SUBMISSION_TIME, COUNT (SM_ID) AS TOTAL_MT
    FROM VAS.SMS_DATA_SMC
    WHERE SUBMISSION_TIME >=
            TO_DATE ('16/12/2018 00:00:00', 'dd/mm/yyyy HH24:MI:SS')
         AND SUBMISSION_TIME <=
                TO_DATE ('16/12/2018 23:59:59', 'dd/mm/yyyy HH24:MI:SS')
         AND MT_MSC_ADDR IS NOT NULL
         AND MT_MSC_ADDR NOT LIKE '569%'
         AND MT_MSC_ADDR <> '0'
         AND FINAL_TIME IS NOT NULL 
    GROUP BY SUBMISSION_TIME
) A
ON A.SUBMISSION_TIME = R1.SUBMISSION_TIME

INNER JOIN
(
    SELECT SUBMISSION_TIME,COUNT (SM_STATUS) AS TOTAL_EXITO_MT_VAS
    FROM VAS.SMS_DATA_SMC
    WHERE SUBMISSION_TIME >=
            TO_DATE ('16/12/2018 00:00:00', 'dd/mm/yyyy HH24:MI:SS')
         AND SUBMISSION_TIME <=
                TO_DATE ('16/12/2018 23:59:59', 'dd/mm/yyyy HH24:MI:SS')
         AND MT_MSC_ADDR IS NOT NULL
         AND MT_MSC_ADDR NOT LIKE '569%'
         AND MT_MSC_ADDR <> '0'
         AND FINAL_TIME IS NOT NULL
         AND SM_STATUS = 1
    GROUP BY SUBMISSION_TIME
) B
ON B.SUBMISSION_TIME = R1.SUBMISSION_TIME

GROUP BY R1.SUBMISSION_TIME, A.TOTAL_MT, B.TOTAL_EXITO_MT_VAS

The result is the following:

What I want to get:

    
asked by Juan Perez 17.12.2018 в 15:48
source

0 answers