SELECT

tx_hash,

staker_address,

amount_usd

FROM

crosschain.olas.ez_olas_staking

SELECT lol

SUM(staking.amount_usd) AS "total amount",

COUNT(DISTINCT staking.tx_hash) AS "total stakes",

COUNT(DISTINCT staking.staker_address) AS "total stakers",

COUNT(DISTINCT staking.tx_hash) / COUNT(DISTINCT staking.staker_address) AS "average stake per staker",

SUM(staking.amount_usd) / COUNT(DISTINCT staking.tx_hash) AS "average volume per stake"

staking;