proposal,

count(distinct voter) as no_of_members,

count(distinct tx_id) as total_votes,

min(block_timestamp) as date_of_creation,

datediff(day, min(block_timestamp::date), CURRENT_DATE) as days_since_first_activity,

max(block_timestamp) as date_of_last_activity,

datediff(day, max(block_timestamp::date), CURRENT_DATE) as days_since_last_activity

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

and realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip'

group by 1

order by 4 desc