SELECT monitoring_session.id, session_date, agent_call, Count(*) AS total JOIN monitoring_campaign ON monitoring_campaign.id = monitoring_session.monitoring_campaign_id
create or replace TRIGGER RATOR_MONITORING.TRG_TRK_SOAP_SERVICE_STATUS ON RATOR_MONITORING_CONFIGURATION.SOAP_SERVICEFOR EACH ROW INSERT INTO RATOR_MONITORING.SOAP_SERVICE_STATUS (SOAP_SERVICE_STATUS_ID,SOAP_SERVICE_ID