SELECT SWAPPER,

COUNT(tx_id) as SWAPS,

SUM(swap_to_amount) as DUST_SWAPPED

FROM solana.fact_swaps

WHERE swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

and succeeded = TRUE

and swap_program = 'jupiter aggregator v2'

GROUP by SWAPPER

),

WALLETS AS (

select

fns.purchaser as WALLET,

COUNT(fns.purchaser) AS DEGODS_PURCHASED

from solana.fact_nft_sales fns

inner join solana.dim_nft_metadata dnm

on lower(dnm.mint) = lower(fns.mint)

where lower(marketplace) like ('magic%')

and succeeded = TRUE

and contract_name = 'DeGods'

GROUP BY 1

SELECT WALLET,

DEGODS_PURCHASED,

SWAPS,

DUST_SWAPPED

from WALLETS

inner join DUSTSWAPPERS

on WALLET = SWAPPER