datavortext1 and t2
Updated 2024-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH relayed_transactions AS (
SELECT
tx_hash
FROM $query('6624cf9a-cb7d-49e4-aff3-b60ec4cf3b02')
),
stake_transactions AS (
SELECT
tx_hash
FROM $query('3e080519-bf92-483a-9ff1-7af637b491ac')
)
SELECT
COUNT(DISTINCT r.tx_hash) AS total_relayed_stake_transactions
FROM
stake_transactions s
JOIN
relayed_transactions r
ON s.tx_hash = r.tx_hash;
QueryRunArchived: QueryRun has been archived