select distinct tx_from[0] as all_address from terra.transactions where

date(block_timestamp) <= DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null

,tbl2 as

select distinct tx_from[0] as new_address from terra.transactions where

date(block_timestamp) > DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null

,tbl3 as

(select new_address from tbl2 left join tbl1 on tbl2.new_address=tbl1.all_address where all_address is null

select count(distinct msg_value:sender) as users ,

(

case

WHEN msg_value:contract='terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' then 'Anchor - bLuna Hub'

WHEN msg_value:contract='terra17yap3mhph35pcwvhza38c2lkj7gzywzy05h7l0' then 'Anchor - bLuna Reward'

WHEN msg_value:contract='terra199t7hg7w5vymehhg834r6799pju2q3a0ya7ae9' then 'Anchor - bLuna Airdrop Registry'

WHEN msg_value:contract='terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' then 'Anchor - Overseer'

WHEN msg_value:contract='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' then 'Anchor - Market'

WHEN msg_value:contract='terra1ptjp2vfjrwh0j0faj9r6katm640kgjxnwwq9kn' then 'Anchor - bLuna Custody'

WHEN msg_value:contract='terra1kq8zzq5hufas9t0kjsjc62t2kucfnx8txf547n' then 'Anchor - Interest Model'

WHEN msg_value:contract='terra14mufqpr5mevdfn92p4jchpkxp7xr46uyknqjwq' then 'Anchor - Distribution Model'

WHEN msg_value:contract='terra1cgg6yef7qcdm070qftghfulaxmllgmvk77nc7t' then 'Anchor - Price Oracle'

WHEN msg_value:contract='terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6' then 'Anchor - Liquidation (Legacy)'

WHEN msg_value:contract='terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5' then 'Anchor - Governance'

WHEN msg_value:contract='terra1897an2xux840p9lrh6py3ryankc6mspw49xse3' then 'Anchor - LP Staking'

WHEN msg_value:contract='terra12wk8dey0kffwp27l5ucfumczlsc9aned8rqueg' then 'Anchor - Community Fund'

WHEN msg_value:contract='terra14ku9pgw5ld90dexlyju02u4rn6frheexr5f96h' then 'Anchor - Fee Collector'

WHEN msg_value:contract='terra1mxf7d5updqxfgvchd7lv6575ehhm8qfdttuqzz' then 'Anchor - Reward Distributor'

WHEN msg_value:contract='terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' then 'Anchor - Airdrop'

WHEN msg_value:contract='terra1939tzfn4hn960ychpcsjshu8jds3zdwlp8jed9' then 'Anchor - bETH Reward'

WHEN msg_value:contract='terra10cxuzggyvvv44magvrh3thpdnk9cmlgk93gmx2' then 'Anchor - bETH Custody'

WHEN msg_value:contract='terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u' then 'Anchor - Liquidation Queue'