select
play_type as type,
-- ,
-- classification,
-- season
count(distinct nft_id) as nfts,
count(distinct team) as teams,
count(distinct player) as players,
row_number() over (order by nfts desc) as rn,
concat(lpad(rn,3,'0'),' - ',type) as typern
from
flow.core.dim_allday_metadata
where
nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by 1
order by rn asc