SELECT count(distinct CONTRACT) as addresses ,case

When CLASS_HASH = '0x03530cc4759d78042f1b543bf797f5f3d647cde0388c33734cf91b7f7b9314a9' then 'Okex'

When CLASS_HASH = '0x058d97f7d76e78f44905cc30cb65b91ea49a4b908a76703c54197bca90f81773' then 'bitstamp'

When CLASS_HASH = '0x025ec026985a3bf9d0cc1fe17326b245dfdc3ff89b8fde106542a3ea56c5a918' then 'argentx'

When CLASS_HASH = '0x03131fa018d520a037686ce3efddeab8f28895662f019ca3ca18a626650f7d1e' then 'braavos' else 'other' end as provider

from external.tokenflow_starknet.decoded_traces

where

CHAIN_ID = 'mainnet'

FUNCTION = 'constructor'

GROUP by 2

order by 2