select
to_char(t.addtime, 'yyyy-mm') as curDate,
count(distinct(t.uuid)) 新注册,
count(distinct case when t.operateid = 1111 then t.uuid else null end) as 新付费用户数,
sum(case when (t.operateid = 1007 or t.operateid = 1005) then t.operatevalue-t.promotevalue else 0 end)/100 as 当月充值金额
from table1 t
where t.operateid in(1005,1007,1111) and t.errorcode=0
and t.addtime>=to_date('2022-01','yyyy-mm')
and t.uuid in (select t1.uuid from table2 t1 where to_char(t1.addtime, 'yyyy-mm') = to_char(t.addtime, 'yyyy-mm'))
group by to_char(t.addtime, 'yyyy-mm')
order by curDate
