select nft_collection, sum(price) as usd_volume, count(tx_id) as sales_count,
CASE
when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA Top Shot'
when nft_collection = 'A.e4cf4bdc1751c65d.AllDay' then 'NFL All Day'
when nft_collection = 'A.329feb3ab062d289.UFC_NFT' then 'UFC Strike'
when nft_collection = 'A.e4cf4bdc1751c65d.PackNFT' then 'NFL All Day - Packs'
end as Collection
from flow.core.fact_nft_sales
group by nft_collection
order by usd_volume desc
limit 4