select

pubkey as Validator,

count (deposit_amount) as deposits_count,

sum (deposit_amount) as total_deposit_volume

from ethereum.beacon_chain.fact_deposits

group by 1)

select

total_deposit_volume || ' ETH' as Volume,

count (distinct validator)

from main_tab

group by 1