select ma.cnt1 as "上周注册用户总数",ma.cnt2 as "上周活跃用户数",ma.cnt3 as "本周活跃用户数",cast (ma.cnt3 as double)/ma.cnt1 as "新用户留存率",cast(ma.cnt3 as double)/ma.cnt2 as "老用户留存率" from
 (select count(1) as cnt1 ,
        sum((case when 
              exists (select 1 from strategy.fcoin_settledetails b where b.settledate between cast(date_add(‘day‘,-5-day_of_week(current_date),{{s_time}})as timestamp)
                                                                        and cast(date_add(‘day‘,-5-day_of_week(current_date),{{e_time}})as timestamp)
                                                                        and b.userid = a.id)
                  then 1 
                  else 0 end)) as cnt2,
        sum((case when 
              exists (select 1 from strategy.fcoin_settledetails b where b.settledate between cast({{s_time}} as timestamp)
                                                                        and cast({{e_time}} as timestamp)
                                                                        and b.userid = a.id)
                  then 1 
                  else 0 end)) as cnt3  
   from cptrd.account_users a 
  where create_time between cast(date_add(‘day‘,-5-day_of_week(current_date),{{s_time}})as timestamp) 
   and cast(date_add(‘day‘,-5-day_of_week(current_date),{{e_time}})as timestamp) )ma