codmes_campana=202410

with sin_feedback as (
    select *
    from (
    select *,
    row_number() over(partition by codmes_campana, num_ruc_hash, num_telefono order by fec_proceso desc) orden 
    from disc_comercial.HM_UNIVERSO_SCORE_RUC_TEL_SF2
    )
    where orden=1
    and cast(codmes_campana as int)={codmes_ejecucion}
),
con_feedback as (
    select *
    from (
    select *,
    row_number() over(partition by codmes_campana, num_ruc_hash, num_telefono order by fec_proceso desc) orden 
    from disc_comercial.HM_UNIVERSO_SCORE_RUC_TEL_CF2
    )
    where orden=1
    and cast(codmes_campana as int)={codmes_ejecucion}
),
despliegue as (
    select codmes_ejecucion, codmes_campana, num_ruc_hash, num_telefono, tip_ruc, prob, universo_2, grupo_contacto
    from sin_feedback
    union 
    select codmes_ejecucion, codmes_campana, num_ruc_hash, num_telefono, tip_ruc, prob, universo_2, grupo_contacto
    from con_feedback
)
select * from despliegue


select * 
from e_perm_aws.scr_empbtctope
limit 10
codmes_ejecucion
codmes_campana
num_ruc_hash
num_telefono
universo_2
prob
segmento_contacto