SELECT
play_type,
sum(price) as volume_usd,
count(tx_id) as sales_count
from flow.core.fact_nft_sales sales
join flow.core.dim_topshot_metadata meta on meta.nft_id=sales.nft_id
where sales.nft_collection='A.0b2a3299cc857e29.TopShot' and TX_SUCCEEDED='TRUE' and currency='A.ead892083b3e2c6c.DapperUtilityCoin'
GROUP BY play_type
ORDER BY volume_usd DESC