Substring(RECEIVER, 0 , charindex('1', RECEIVER) -1) as Chain,

count(*)

from osmosis.core.fact_transfers

where transfer_type like 'IBC_TRANSFER_OUT'

and RECEIVER not like '0x%'

group by 1

having count(*) > 10

order by 2 DESC