from crosschain.address_labels

where blockchAIN = 'solana' and label_type = 'nft')

SELECT project_name, avg(amt)/pow(10,9) as avg_price,

sum(amt)/pow(10,9) as total_sales,

count(*) as total_txs

from

(SELECT * from

(SELECT *,

mint_price as amt

from solana.core.fact_nft_mints

--where array_size(inner_instruction:instructions) > 4

-- where program_Id = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'

)

inner join

addr

on mint = address )

where amt is not NULL

GROUP by 1

order by 4 desc

limit 10