saeedmznNFL All Day Tournament [Round 1] - Top 10 NFTs
    Updated 2022-09-13
    with NFLallDay as (
    select EVENT_CONTRACT, CONTRACT_NAME
    from flow.core.dim_contract_labels
    where contract_name ='AllDay'
    group by 1,2
    )
    select player,
    price
    from flow.core.ez_nft_sales FULL join flow.core.dim_allday_metadata using (nft_id)
    where NFT_COLLECTION in (select EVENT_CONTRACT from NFLallDay )
    and tx_succeeded = 'TRUE'
    group by 1,2 order by price desc limit 10
    Run a query to Download Data