stake_pool_name,

count(distinct tx_id) AS transactioncount,

sum(amount) AS totalamountstaked

from solana.defi.fact_stake_pool_actions

where block_timestamp :: date between '2024-11-01' AND '2024-11-30'

group by stake_pool_name

order by transactioncount desc

limit 5;