Paste code

SELECT periodo_campania, 
           num_ruc,
           MAX(CASE WHEN lower(gestion_tipo) LIKE &#039;%acepta%&#039; AND lower(gestion_tipo) NOT LIKE &#039;%no%&#039; AND lower(gestion_tipo) NOT LIKE &#039;%visita%&#039; THEN 1 ELSE 0 END) flg_acepta_vpconnect
        FROM d_mdl_vpc_disc.HM_GESTION_VPCONNECT_SQAD C
        WHERE 1 = 1
        and periodo_campania >= &#039;202206&#039;
        AND lower(tipo_campania) LIKE &#039;%adq%&#039;
        AND (
            flg_activo = 1 OR (gestion_tipo IS NOT NULL AND gestion_tipo NOT LIKE &#039;&#039;)
        )
        AND NUM_RUC IS NOT NULL
        AND NUM_RUC NOT LIKE &#039;&#039;
        AND NUM_RUC != &#039;.&#039;
        GROUP BY periodo_campania, num_ruc
        ORDER BY periodo_campania DESC, num_ruc