select team, count (*) as Count_of_NFTs
from flow.core.dim_topshot_metadata
where team not in ('Los Angeles Sparks','Minnesota Lynx', 'Washington Mystics', 'Chicago Sky', 'Seattle Storm', '
Phoenix Mercury','Indiana Fever',' Dallas Wings','Atlanta Dream','Las Vegas Aces','Connecticut Sun', 'New York Liberty', 'San Antonio Silver Stars','Sacramento Monarchs', 'Dallas Wings','Houston Comets','Phoenix Mercury', 'Detroit Shock', 'Los Angeles Clippers')
group by team
order by Count_of_NFTs desc
limit 8