SELECT
PROGRAM_NAME,
SUM(REWARD) AS total_rewards,
AVG(REWARD) AS average_reward,
COUNT(*) AS checkpoint_count,
MIN(BLOCK_TIMESTAMP) AS first_checkpoint,
MAX(BLOCK_TIMESTAMP) AS last_checkpoint
FROM
crosschain.olas.ez_service_checkpoints
GROUP BY
PROGRAM_NAME
ORDER BY
total_rewards DESC;
-- مرتبسازی بر اساس بیشترین پاداش