LittlerDataPreferred Payment Method
    Updated 2022-10-22
    with buyers as (
    select
    distinct buyer
    from flow.core.ez_nft_sales
    where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT'
    )

    select
    avg(price)
    ,currency
    ,count(distinct tx_id) as times_currency_used
    from flow.core.ez_nft_sales
    where nft_collection not like 'A.329feb3ab062d289.RaceDay_NFT'
    and buyer in (select buyer from buyers)
    group by 2
    Run a query to Download Data