with link as

(select

PERMISSION:FunctionCall:receiver_id as contract,

count(tx_hash) as trans

FROM near.core.fact_actions_events_addkey

where PERMISSION:FunctionCall:receiver_id is not null

and block_timestamp >= '2021-09-01'

group by 1

order by 2 DESC

)

select sum(trans)

from link