ArioNFL All Day Tournament [Round 1] - correlation of player position and play-Type
    Updated 2022-09-14
    with NFL_data as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    NFT_COLLECTION a,
    NFT_ID,
    BUYER,
    SELLER,
    PRICE
    from flow.core.fact_nft_sales
    where NFT_COLLECTION ilike '%allday%'
    and PRICE is not null
    and TX_SUCCEEDED = 'TRUE'
    ),
    NFL_Total_data as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    NFT_COLLECTION,
    d.NFT_ID,
    BUYER,
    SELLER,
    PRICE,
    player,
    team,
    PLAY_TYPE,
    MOMENT_STATS_FULL:metadata:playerPosition as PlayerPosition
    from NFL_data d Inner join flow.core.dim_allday_metadata m on d.NFT_ID = m.NFT_ID
    )
    select
    PlayerPosition,
    PLAY_TYPE,
    avg(Price) as avg_price,
    row_number() over(order by avg_price) as row_number
    from NFL_Total_data
    group by 1,2
    Run a query to Download Data