feyikemi2024-04-29 05:42 PM
Updated 2024-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
WITH Chains as (
SELECT
source_chain,
destination_chain,
COUNT(DISTINCT Tx_hash) AS transactions
FROM
AXELAR.defi.ez_bridge_squid
GROUP BY
1, 2
UNION ALL
SELECT
Source_chain,
destination_chain,
COUNT(DISTINCT tx_hash) AS transactions
FROM
AXELAR.defi.ez_bridge_satellite
GROUP BY
1, 2
)
SELECT
CONCAT(source_chain, ' -> ', destination_chain) AS Chain_pairs,
transactions
FROM chains
ORDER BY 2 DESC
LIMIT 10
QueryRunArchived: QueryRun has been archived