droptableappcjrsselecta1.日期2,day(a1.日期2)as日,convert(varchar(7),a1.日期2,111)as年月,a1.kacnapp售出人数,a1.kacnapp累计售出人数,a2.kltapp售出人数,a2.kltapp累计售出人数,isnull(a1.kacnapp售出人数,0)+isnull(a2.kltapp售出人数,0)as两站售出人数,isnull(a1

droptablexkhokr_kacnselectdistinct日期2,day(日期2)as日,convert(varchar(7),日期2,111)as年月,count(*)askacn新客户售出人数intoxkhokr_kacnfrom(selectdistinct日期2,会员idfromkacn售出where日期2between'2022-07-01'and'2022-09-30'and会员idis

droptabledkhokrselectdistinct日期2,会员id,day(日期2)as日,convert(varchar(7),日期2,111)as年月,sum(cast(订单金额asreal))as售出金额intodkhokrfromkaka售出where日期2between'2022-07-01'and'2022-09-30'and会员idisnotnullgroupby日期2,会员ido