with voters_tb as (
select 'voters' as MakerDao , count(distinct voter) as unique_voters
from ethereum.maker.ez_governance_votes
group by MakerDao
),
votes_tb as (
select 'votes'as MakerDao , count(distinct tx_hash) as unique_votes
from ethereum.maker.ez_governance_votes
group by MakerDao
),
proposals_tb as (
select 'proposals'as MakerDao , count(distinct proposal_id) as unique_proposals
from ethereum.maker.ez_governance_votes
group by MakerDao
)
select * from voters_tb
UNION
select * from votes_tb
UNION
select * from proposals_tb