The WITH clause defines a common table expression (CTE), which is a temporary named result set. The definition of a CTE includes its name, an optional list of column names, and a query expression (that is, a SELECT statement).
For more information about SELECT statements, see SELECT.
{% code title="Example" %}
[ WITH <cte_name> [ ( <cte_column1>, <cte_column2>, ... ) ]
AS ( <query> )
]
SELECT ...{% endcode %}
[ WITH <cte_name> [ ( <cte_column1>, <cte_column2>, ... ) ] AS ( <query> ) ] String
A temporary named result set for use in the statement that defines the CTE.
<cte_name>: The name of the CTE you are defining. The CTE must have a unique name within a given query.<cte_column#>: The names of the columns from the query that defines the CTE.AS <query>: The query (SELECT) statement that defines the CTE.
with eth_withdrawn as (
select eth.withdrawals.block_number, SUM(amount) as amount_gwei
from eth.withdrawals
group by eth.withdrawals.block_number
order by block_number asc)
select AVG(amount_gwei / 1e9) as amount_eth
from eth_withdrawn
\