SUM function

[iankressin]

Description

The SUM function must reduce all column values to a single value by adding the values together.

Syntax

SUM accepts a query as parameter, and all the fields specified in that query must be numeric.

Definition:

query = GET <[fields, ]> FROM <entity> <[entity_id, ]> ON <chain>
SUM(<query>)

Examples:

# ACCOUNTS

# ✅ Valid query
SUM(GET balance FROM account vitalik.eth ON eth, base, arb)

# ❌ Invalid query: cannot sum addresses
SUM(GET balance, address FROM account vitalik.eth ON eth, base, arb)

# TRANSACTIONS

# ✅ Valid query
SUM(GET value FROM tx WHERE block = latest ON eth, base, arb)

# ❌ Invalid query: cannot sum hashes
SUM(GET value, hash FROM tx WHERE block = latest ON eth, base, arb)