select PURCHASER

,SELLER

from solana.core.fact_nft_sales

where BLOCK_TIMESTAMP>='2023-01-06' and BLOCK_TIMESTAMP<='2023-05-06'

and MARKETPLACE='tensorswap'),

tab2 as (

select ADDRESS

,LABEL

,LABEL_TYPE

from solana.core.dim_labels),

tab3 as (

select

case

when BLOCK_TIMESTAMP>='2023-03-06' and BLOCK_TIMESTAMP<='2023-05-06' then 'TWO MONTHS AFTER AIRDROP ANNOUNCE'

when BLOCK_TIMESTAMP>='2023-01-06' and BLOCK_TIMESTAMP<'2023-03-06' then 'TWO MONTHS BEFORE AIRDROP ANNOUNCE'end as announce_time

,SIGNERS[0] as user

,TX_ID

,PROGRAM_ID

from solana.core.fact_events

where BLOCK_TIMESTAMP>='2023-01-06' and BLOCK_TIMESTAMP<='2023-05-06'

and SUCCEEDED='true')

select announce_time

,LABEL

,LABEL_TYPE

,case

when LABEL_TYPE in('nft') then 'NFT'

when LABEL_TYPE in('layer2') then 'LAYER2'

when LABEL_TYPE in('dex') then 'DEX'

when LABEL_TYPE in('defi') then 'DEFI'

when LABEL_TYPE in('dapp') then 'DAPP' else 'OTHERS'

end as Interaction

,count(distinct TX_ID) as txs

,count(distinct user) as users

from tab2

left join tab3