sum(amount ) as total ,

count(TX_ID) as count_tx ,

a.NODE_ID as node_address ,

iff(PROJECT_NAME is NULL , a.node_id , project_name) as name

from flow.core.ez_staking_actions a left JOIN flow.core.dim_validator_labels b using(NODE_ID)

where

block_timestamp::date >current_date- {{date_range}}

and (action='DelegatorTokensCommitted' or action='TokensCommitted' )

and tx_succeeded = 'TRUE'

group by PROJECT_NAME ,node_address