with

snapshot as

(select

count(distinct ID) as "Votes" ,

count(distinct PROPOSAL_ID) as "Proposal Id" ,

count(distinct VOTER) as "Voters" ,

min(distinct datediff('day',PROPOSAL_END_TIME::date,current_date)) as "Last Proposal",

avg (VOTING_POWER) as "Average Voting Power",

Min(VOTING_POWER) as "Min Voting Power",

max(VOTING_POWER) as "Max Voting Power"

from external.snapshot.ez_snapshot

where SPACE_ID = 'toshibase.eth'

select * from snapshot