SELECT
token_name,
sum(sales_amount) as sales_volume,
count(DISTINCT tx_id) as sales_events
FROM solana.core.fact_nft_sales
LEFT OUTER JOIN solana.core.dim_nft_metadata
ON solana.core.fact_nft_sales.mint = contract_address
--WHERE NOT token_name is NULL
where token_name like('%Runners%')
GROUP BY 1
ORDER BY 2 DESC
LIMIT 20