with velodrome_claimed_rewards as (
select
block_timestamp,
tx_hash,
origin_from_address,
concat(split(reward_type, '_')[0], ' ', split(reward_type, '_')[1]) as reward_type,
claimed_amount_usd as rewards_amount
from optimism.velodrome.ez_claimed_rewards
where block_timestamp <= current_date - 1
)
select
block_timestamp::date as "Days",
reward_type as "Reward Type",
count(tx_hash) as "Number of Claimed Rewards",
count(tx_hash) as "Number of Rewards Claimer",
sum(rewards_amount) as "Amount of Claimed Rewards"
from velodrome_claimed_rewards
group by "Days", "Reward Type"