ADDRESS,

COUNT(*) AS transaction_count,

SUM(AMOUNT) AS total_amount

FROM

solana.defi.fact_stake_pool_actions

WHERE

STAKE_POOL_NAME = 'marinade'

AND TOKEN = 'SOL'

GROUP BY

ADDRESS

ORDER BY

transaction_count DESC, total_amount DESC

Limit 5;