kingharald-ethWhich play_type users hold most
    Updated 2022-07-26
    select list3.play_type, count(distinct(list2.buyer)) as wallets from flow.core.fact_transactions list1
    join flow.core.fact_nft_sales list2 on list2.tx_id = list1.tx_id
    join flow.core.dim_topshot_metadata list3 on list3.nft_id = list2.nft_id and list3.nft_collection = list2.nft_collection
    where list1.tx_succeeded = 1
    and list2.nft_collection = 'A.0b2a3299cc857e29.TopShot'
    group by list3.play_type
    Run a query to Download Data