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