select SWAPPER,sum(swap_to_amount) as "buy amount"

from solana.fact_swaps

where

SUCCEEDED = TRUE and

SWAP_TO_MINT = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

group by SWAPPER

),degods_address as (

select MINT,CONTRACT_NAME from solana.dim_nft_metadata where CONTRACT_NAME='DeGods'

),degods_purchaser as (

select DISTINCT purchaser

from solana.fact_nft_sales

where

SUCCEEDED = TRUE and

marketplace in ('magic eden v1','magic eden v2') and

MINT in (select MINT from degods_address)

select

sum(iff(SWAPPER=purchaser,1,0)) as "purches with swaps",

sum(iff(SWAPPER=purchaser,"buy amount",0)) as "amount $dust bought by purches with swaps",

sum("buy amount") as "total amount dust bought",

sum(1) as "dust swappers",

"purches with swaps"/"dust swappers" * 100 as "percentage user purches with swap among dust swapers",

"amount $dust bought by purches with swaps"/"total amount dust bought" * 100 as "percentage $Dust Bought by DeGods purcheser amonng all Dust bought"

from dust_swappers left join degods_purchaser on swapper=purchaser