Abbas_ra212023-08-27 08:57 PM
Updated 2023-08-28
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
›
⌄
with main AS (
select
From_address,
TX_HASH,
TX_FEE
from
aurora.core.fact_transactions
inner join (
select
FROM_ADDRESS AS User,
min(BLOCK_TIMESTAMP) AS Timdate
from
aurora.core.fact_transactions
group by
1
) on User = From_address
and Timdate = Timdate
where
TX_Fee = 0
)
select
Count(DISTINCT From_address)
from
main
Run a query to Download Data