Nft_name,

Nft_collection_name,

SUM(SALES_AMOUNT) AS sol_vol,

from solana.nft.fact_nft_sales s

LEFT JOIN solana.nft.dim_nft_metadata l

ON s.mint = l.mint

GROUP BY 1, 2

HAVING sol_vol != 0

AND

NFT_Name LIKE '%Clayno%'

ORDER BY 3 DESC

LIMIT 10