count(*) as number,

date_trunc('day',BLOCK_TIMESTAMP) as date ,case when date>'2023-01-14' then 'After lunch' else 'before lunch' end as type

from

terra.core.fact_governance_submit_proposal

group by 2,3

order by 1 asc