DECLARE @se VARCHAR(250);
DECLARE @gerencia VARCHAR(20);

SET @gerencia='GGEN'

SET @se = (SELECT CASE @gerencia
    WHEN 'GGEN' THEN '''AUTOMATI'',''EQELEAUX'',''HIDROREG'',''TALLERMM'',''OTGENERA'',''MAQPPLMM'',''MAQPPLME'',''MAQAUXMM'',''TMEDELE'''
    WHEN 'GTRA' THEN '''SESGASGU'',''SESANJAV'',''SECOELIA'',''PROTELEC'',''OTTRANSM'',''MEDELECT'',''MANTSSEE'',''LINEASTR'',''SUBESTAC'',''OPESUB'',''LABSSEE'''
    END);

SELECT COUNT(*) FROM r5events WHERE evt_class IN (@se)

SELECT COUNT(*) FROM r5events WHERE evt_class IN ('AUTOMATI','EQELEAUX','HIDROREG','TALLERMM','OTGENERA','MAQPPLMM','MAQPPLME','MAQAUXMM','TMEDELE')