with mint_address as (

select origin_from_address as minter, sum(event_inputs:tokenAmount) as mints

from avalanche.core.fact_event_logs

where origin_to_address=lower('0xcFd8402927f07A4D1e4DFe7f9C60f6EbF9Ed3673') and event_name='Mint'

group by minter),

tx_list as (

select count(DISTINCT tx_hash) as no_tx, min(block_timestamp) as earliest_tx_date,

datediff(day,date(earliest_tx_date),'2022-07-21' ) as date_diff, origin_from_address as wallet_address

from avalanche.core.fact_event_logs

group by wallet_address

select *, case when no_tx>1000 then 1000 else no_tx end as no_tx2

from mint_address

left join tx_list on minter=wallet_address

where mints>1