address_name,

count(token_id) as cnt

from

solana.core.dim_nft_metadata a join solana.core.dim_labels b on a.MINT=b.ADDRESS

where

address_name in ('Hockey Heroes','Collectorz Club: The Collectorz','collectorz club gen1','The Suites','Laidback Lions','Sports Rewind')

group by

1

order by

2 desc