farid-c9j0VMNFT collections by sales volume since january 1th 2022
    Updated 2022-07-01
    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



    Run a query to Download Data