AVG(gas_price), -- apply aggregate function to columns that are not being grouped

trunc(block_timestamp, 'day') as time -- truncates each timestamp to its day

optimism.core.fact_transactions

WHERE

time > '2022-01-01' -- YYYY-MM-DD format

time != '2022-03-11' -- Omit outlier

GROUP BY

time

ORDER BY

time DESC;