drop table xkhokr_kacn
select distinct 日期2,day(日期2) as 日,convert(varchar(7),日期2,111) as 年月,count(*) as kacn新客户售出人数
into xkhokr_kacn
from (
select distinct 日期2,会员id from kacn售出 where 日期2 between '2022-07-01' and '2022-09-30' and 会员id is not null
and 新老客户='新客户'
) as aa
group by 日期2
order by 日期2
drop table xkhokr_kacn1
select a.日期2,a.日,a.年月,a.kacn新客户售出人数,sum(b.kacn新客户售出人数) as kacn新客户累计人数
into xkhokr_kacn1
from xkhokr_kacn as a,xkhokr_kacn as b
where b.日<=a.日 and b.年月=a.年月
group by a.日期2,a.日,a.年月,a.kacn新客户售出人数