winnie-fsTransaction count score copy
Updated 2023-10-19
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
32
33
34
35
36
›
⌄
-- personal query
-- forked from Mrfti / Transaction count score @ https://staging.flipsidecrypto.xyz/Mrfti/q/mD4nh_faYo40/transaction-count-score
SELECT
'Having more than 4 transaction' as condition,
'1' as point,
case
when count (DISTINCT tx_hash) > 3 then '🟢'
else '🔴'
end as true_false
from base.core.fact_transactions
where from_address =lower('{{ADDRESS}}')
union all
SELECT
'Having more than 10 transaction' as condition,
'1' as point,
case
when count (DISTINCT tx_hash) > 9 then '🟢'
else '🔴'
end as true_false
from base.core.fact_transactions
where from_address =lower('{{ADDRESS}}')
union all
SELECT
'Having more than 25 transaction' as condition,
'1' as point,
case
when count (DISTINCT tx_hash) > 24 then '🟢'
else '🔴'
end as true_false
from base.core.fact_transactions
Run a query to Download Data