count (distinct tx_hash) as Renews_Count,

count (Distinct origin_from_address) as Renewers_Count,

sum (Renews_Count) over (order by date) As Cumulative_Renews_Count

from ethereum.core.ez_decoded_event_logs

where contract_address = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85'

and tx_status = 'SUCCESS'

and event_name ='NameRenewed'

and block_timestamp >= '2023-01-01' and block_timestamp < '2024-01-01'

group by 1

order by 1