case

-- when left(token_metadata_uri,12) = 'https://ipfs' then '0-ipfs'

-- when left(token_metadata_uri,4) = 'ipfs' then '0-ipfs'

when token_metadata_uri like '%ipfs%' then concat('0-ipfs?-',left(token_metadata_uri,35))

when left(token_metadata_uri,15) = 'https://arweave' then '0-arweave'

when left(token_metadata_uri,10) = 'https://s3' then '0-s3'

when left(token_metadata_uri,27) = 'https://storage.googleapi' then '0-google'

else left(token_metadata_uri,25)

end as uri_checker,

count( distinct PROJECT_NAME) as projects,

count(distinct token_id) as tokens

from

ethereum.core.dim_nft_metadata

group by 1

order by 3 desc

limit 100