“KP工作台数据漏斗（二期）”的版本间的差异

select
    stat_date as statDate,
    adm_amt_1d as admAmt  
from
    dwp_en_dm_comp_maincatelv2_eff_d  
where
    (
        stat_date >= '2018-11-20'          
        and stat_date <= '2018-11-23'      
    )      
    and admin_mbr_seq = '14' 
order by
    stat_date ASC

from
    dwp_en_dm_comp_term_catelv2_eff_d     
where
    ( stat_date >= #{startDate}
       and stat_date <= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}
    and is_main_cate = "Y"
    and terminal_type="TOTAL"
order by
    stat_date ASC

select
    ${returnFields}
from
    dwp_en_dm_comp_maincatelv2_eff_d   
where
    ( stat_date >= #{startDate}
       and stat_date <= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}
order by
    stat_date ASC