with A as(
SELECT
address_name,tx_from,
sum(amount) as "total amount"
FROM solana.core.fact_transfers st
JOIN solana.core.dim_labels sl ON st.tx_to = sl.address
WHERE mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
AND LABEL_TYPE = 'cex'
AND block_timestamp >= '2022-08-01'
group by 1,2
order by 3 desc
limit 10)
SELECT
sum("total amount")
from A