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: