Eman-RazDistribution of Users By Number of Daily Checking
Updated 2024-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (select origin_from_address as user, count(distinct tx_hash), case
when count(distinct tx_hash)<=1 then 'n=1'
when count(distinct tx_hash)>1 and count(distinct tx_hash)<=5 then '1<n<=5'
when count(distinct tx_hash)>5 and count(distinct tx_hash)<=10 then '5<n<=10'
when count(distinct tx_hash)>10 and count(distinct tx_hash)<=50 then '10<n<=50'
when count(distinct tx_hash)>50 and count(distinct tx_hash)<=100 then '50<n<=100'
when count(distinct tx_hash)>100 then 'n>100'
end as "Class"
from blast.core.fact_event_logs
where origin_function_signature='0x183ff085'
and tx_status='SUCCESS'
and origin_to_address='0x5ff315aa82a8b2b435f866d20ecd46959999bdcd'
group by 1)
select "Class", count(distinct user) as "User Count"
from tab1
group by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived