rach2024-05-16 12:22 PM
Updated 2024-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
TX_TYPE,
AVG(gas_fee) AS average_gas_fee,
SUM(gas_fee) AS total_gas_fee
FROM (
SELECT
GAS_PRICE * GAS_USED AS gas_fee,
TX_TYPE
FROM
ethereum.core.fact_transactions
UNION ALL
SELECT
GAS_PRICE * GAS_USED AS gas_fee,
TX_TYPE
FROM
polygon.core.fact_transactions
) AS combined_transactions
GROUP BY TX_TYPE;