SELECT

TX_TO,

sum(amount) as volume,

count(DISTINCT tx_from) as senders,

count(DISTINCT tx_id) as events

FROM solana.core.fact_transfers

WHERE mint LIKE 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

GROUP BY 1

HAVING NOT volume is NULL

ORDER by 2 DESC

LIMIT 10

SELECT *

FROM tab1

LEFT outer JOIN solana.core.dim_labels

ON address = tx_to