select mint

,SALES_AMOUNT

from solana.core.fact_nft_sales

where succeeded = 'TRUE'

and marketplace = 'exchange art'

),

tab2 as (

select MINT,TOKEN_NAME,TOKEN_METADATA_URI

from solana.core.dim_nft_metadata)

select tab2.mint,TOKEN_METADATA_URI,TOKEN_NAME,sum(SALES_AMOUNT) as sale_volume

from tab1

left join tab2

on tab1.mint=tab2.mint

where tab2.mint is not null

group by 1,2,3

order by 4 desc

limit 20