select token_name,mint

from solana.dim_nft_metadata),

tab2 as(

select mint,sum(sales_amount)as total_sale, count(distinct purchaser)as purchas_wallet

from solana.fact_nft_sales

group by 1)

select tab1.token_name,sum(tab2.total_sale)as total_full_sale,count(tab2.purchas_wallet) as purchaser_wallets

from tab1

left join tab2

on tab1.mint=tab2.mint

group by 1