feyikemiAxelar GMP copy
Updated 2024-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from dannyamah / Axelar GMP @ https://flipsidecrypto.xyz/dannyamah/q/gDHA76AhB3R2/axelar-gmp
WITH gmp AS (
SELECT
count(DISTINCT fact_gmp_id) AS gmp
FROM axelar.axelscan.fact_gmp
),
transfers AS (
SELECT
count(DISTINCT fact_transfers_id) AS transfers
FROM axelar.axelscan.fact_transfers
)
SELECT
gmp,
transfers,
gmp + transfers AS total_tx
FROM gmp, transfers
QueryRunArchived: QueryRun has been archived