feyikemiBridged Txn %
Updated 2024-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH total_transactions AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_txns
FROM base.core.fact_transactions
WHERE status = 'SUCCESS'
),
bridged_transactions AS (
SELECT
COUNT(DISTINCT tx_hash) AS bridged_txns
FROM base.defi.ez_bridge_activity
)
SELECT
bridged_transactions.bridged_txns,
total_transactions.total_txns,
(bridged_transactions.bridged_txns / total_transactions.total_txns) * 100 AS percentage_bridged_txns
FROM bridged_transactions
CROSS JOIN total_transactions;
QueryRunArchived: QueryRun has been archived