KeyrockAVG Tx Per Wallet
Updated 2024-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH total_wallet AS (
SELECT
COUNT(DISTINCT tx_from) AS tot_wallet
FROM
sei.core.fact_transactions
WHERE
TX_SUCCEEDED = TRUE
),
total_transactions AS (
SELECT
COUNT(DISTINCT FACT_TRANSACTIONS_ID) AS tot_transaction
FROM
sei.core.fact_transactions
)
SELECT
tot_transaction / tot_wallet AS avg_tx_per_wallet
FROM
total_wallet,
total_transactions;
QueryRunArchived: QueryRun has been archived