select

'lava' as metric,

count(distinct tx_id) as total_transaction,

from lava.core.fact_transactions

where tx_succeeded = 'TRUE'

),

addresses as (

select

'lava' as metric,

count(distinct tx_from) as total_addresses

from lava.core.fact_transactions

where tx_succeeded = 'TRUE'

),

staking as (

select

'lava' as metric,

count(distinct delegator_address) as stakers

from lava.gov.fact_staking

),

validators as (

select

'lava' as metric,

count(distinct validator_address) as validators

from lava.gov.fact_staking

select t.total_transaction as total_transaction,

a.total_addresses as addresses,

s.stakers,

v.validators

from transaction t

join addresses a ON a.metric = t.metric

join staking s ON s.metric = t.metric