SQL for getting event count

events.sql

SELECT event_id, event_label, total
FROM (SELECT DISTINCT
    CASE pipeline_name
        WHEN 'Transfer'::text
        THEN 'Archive'::text
        ELSE
            CASE xs_lastposition('/'::text, pipeline_name::text)
                WHEN 0
                THEN pipeline_name
                ELSE substring(substring(pipeline_name::text, xs_lastposition('/'::text, pipeline_name::text) + 1), 1, xs_lastposition('.'::text, substring(pipeline_name::text, xs_lastposition('/'::text, pipeline_name::text) + 1)) - 1)
            END
    END AS event_label,
    pipeline_name AS event_id,
    count(*) AS total
    FROM (SELECT *
        FROM wrk_workflowData
        WHERE externalid !='ADMIN' AND
              externalid !='' AND
              externalid IS NOT NULL AND
              launch_time > now() - '1 year'::interval) AS current
    GROUP BY event_id, event_label) AS events
WHERE total > 1;