from_address,

COUNT(*) AS num_transactions,

AVG(gas_used) AS avg_gas_used,

MAX(gas_used) AS max_gas_used,

MIN(gas_used) AS min_gas_used

FROM base.goerli.fact_transactions

GROUP BY from_address

ORDER BY num_transactions DESC

LIMIT 10