select tx_id,

nft_id,

sum(price) as price2

from flow.core.fact_nft_sales

where nft_collection = 'A.0b2a3299cc857e29.TopShot'

and currency = 'A.ead892083b3e2c6c.DapperUtilityCoin'

and block_timestamp > '2022-01-01'

group by nft_id, tx_id

order by price2 DESC

)

play_type,

sum(price2) as volume,

player

from flow.core.dim_topshot_metadata m

inner join sales s on s.nft_id = m.nft_id

where player in ('Jayson Tatum', 'Magic Johnson', 'Steph Curry', 'Scottie Barnes', 'Ja Morant')

group by play_type, player

order by volume desc