DISTINCT a.mint AS Token,

COUNT (b.tx_id),

address_name AS Name

FROM solana.core.fact_transfers a

JOIN solana.core.fact_transactions b

ON a.block_timestamp = b.block_timestamp

JOIN solana.core.fact_events c

ON a.block_timestamp = c.block_timestamp

JOIN solana.core.dim_labels d

ON a.mint = d.address

WHERE program_id = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

GROUP BY 1,3

ORDER BY 2 DESC

LIMIT 10;