BLOCK_TIMESTAMP::date as date,

ROW_NUMBER() OVER(partition by VOTE_OPTION_TEXT ORDER BY date asc) AS Number_of_the_day,

VOTE_OPTION_TEXT, count(DISTINCT TX_ID) as votes

from terra.core.fact_governance_votes

where TX_SUCCEEDED and PROPOSAL_ID = '3665'

group by 1,3