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,

CASE

WHEN to_address IS NULL THEN 'Contract Creation'

WHEN to_address <> from_address THEN 'External Transaction'

ELSE 'Internal Transaction'

END AS transaction_type

FROM base.goerli.fact_transactions

where status='SUCCESS'

GROUP BY transaction_type