play_type,

COUNT(PLAY_TYPE) as holder

from flow.core.dim_topshot_metadata x, flow.core.fact_nft_sales y

where x.nft_id = y.nft_id

AND TX_SUCCEEDED = 'TRUE'

GROUP by 1

ORDER by 2 DESC