label as CEX,sum(amount) as Volume_SOL,

count(distinct tx_id) as "COUNT_OF_Transactions"

from solana.core.fact_transfers

inner join solana.core.dim_labels on (tx_from = address)

where label_type = 'cex'

and mint = 'So11111111111111111111111111111111111111112'

and block_timestamp >= '2022-10-01'

group by

1,

2