A.play_type as "Play Type",---GENERAL FAVRUIOT

count (DISTINCT M.tx_id) as sales, sum(M.price) as "amount USD" --Sales volume of usd

from flow.core.dim_topshot_metadata A--us general tabel

join flow.core.fact_nft_sales M

on A.NFT_ID = M.NFT_ID

where M.TX_SUCCEEDED = 'TRUE'---Successful transactions

and M.CURRENCY like '%DapperUtilityCoin%'

GROUP by "Play Type"

order by 3 DESC