SELECT
DISTINCT PROGRAM_NAME,
COUNT(*) AS transaction_count,
SUM(AMOUNT_USD) AS total_staked,
AVG(AMOUNT_USD) AS avg_stake_amount,
COUNT(DISTINCT STAKER_ADDRESS) AS unique_stakers
FROM
crosschain.olas.ez_olas_staking
GROUP BY PROGRAM_NAME
ORDER BY
total_staked DESC;