select

date(proposal_start_time) as start_date,

space_id,

proposal_id,

proposal_title

from ethereum.core.ez_snapshot

),

proposals as (

select

-- start_date,

space_id,

count(distinct proposal_title) as num_props

from a_s

group by 1),

grouped as (

select

start_date,

proposal_title,

space_id as DAO

from a_s

where start_date > '2022-01-01'

select

DAO,

count(distinct proposal_title) as "Number of Proposals"

from grouped

group by 1

order by "Number of Proposals" desc