SELECT S1.TRANSACTION_ID AS TRANSACTION_ID,
       S1.PARENT_TRANSACTION_ID AS PARENT_TRANSACTION_ID,
       S1.SENT_TIME AS SENT_TIME,
       S1.OPERATION_NAME AS OPERATION_NAME,
       S1.NAMESPACE AS NAMESPACE,
       COUNT(S2.FILENAME) AS FILECOUNT
FROM JMS_ESB_PROPERTY S1 INNER JOIN JMS_ESB_PROPERTY S2
ON S1.TRANSACTION_ID = S2.TRANSACTION_ID AND
       S1.NAMESPACE = 'IMS_ESB_T_VasaroltKovetelescsomagok' AND
       S1.OPERATION_NAME = 'VasaroltKovetelescsomagok' AND
       S1.SENT_TIME > '09-MAR-2018' AND
       S1.SENT_TIME < '31-MAR-2018'
GROUP BY S1.TRANSACTION_ID, S1.PARENT_TRANSACTION_ID, S1.SENT_TIME, S1.OPERATION_NAME, S1.NAMESPACE
ORDER BY S1.TRANSACTION_ID;
GROUP BY S1.TRANSACTION_ID, S1.PARENT_TRANSACTION_ID, S1.SENT_TIME, S1.OPERATION_NAME, S1.NAMESPACE
ORDER BY S1.TRANSACTION_ID;