create table tst1
(agents varchar(5),
trig varchar(5),
trig2 varchar(5)
)

SELECT trig,COUNT(*)
FROM (
    SELECT agents,trig
    FROM tst1
    UNION ALL
    SELECT agents,trig2
    FROM tst1
)t1
GROUP BY trig