Query editor
WITH yearly_deployments AS (SELECTDATE_TRUNC('year', evt_block_time) AS period,protocol,COUNT(*) AS accounts_deployedFROM dune.safe.result_smart_accounts_deployed_infoWHERE evt_block_time >= timestamp '2020-01-01'GROUP BY 1, 2)SELECTperiod,protocol,SUM(accounts_deployed) OVER (PARTITION BY protocol, DATE_TRUNC('year', period)) AS total_accounts_deployedFROM yearly_deploymentsORDER BY period DESC, protocol DESC