mamad-5XN3k3Aptos Quests 2
Updated 2024-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
/*select *
from aptos.core.fact_events
where tx_hash in ('0x9280f315e295ed62d5fcb1ff9454a7bab92002429aa1bf52ab6c5f28c6bb162e',
'0xe4ea8fa1a16db8273b025dd4bcf5a6be2186cd8a5acdc7d2f89640cb409d857e')*/
SELECT
case
when EVENT_DATA:token_data_id:name = 'Aptos Ecosystem Fundamentals - Quest One' then 'Quest One'
when EVENT_DATA:token_data_id:name = 'Quest Two - Aptos Ecosystem Fundamentals' then 'Quest Two'
when EVENT_DATA:token_data_id:name = 'Quest Three - Aptos Ecosystem Fundamentals' then 'Quest Three'
else 'Quest Four' end as Quests,
count(distinct EVENT_DATA:receiver_addr) as users
from aptos.core.fact_events
where EVENT_DATA:token_data_id:collection= 'Galxe OAT'
and EVENT_RESOURCE = 'ClaimEvent'
and EVENT_MODULE = 'oat'
and EVENT_INDEX = '4'
--and EVENT_DATA:token_data_id:name ilike '%Aptos Ecosystem Fundamentals'
and EVENT_DATA:token_data_id:name in ('Quest Three - Aptos Ecosystem Fundamentals','Aptos Ecosystem Fundamentals - Quest One'
,'Quest Four - Aptos Ecosystem Fundamentals','Quest Two - Aptos Ecosystem Fundamentals')
group by 1
QueryRunArchived: QueryRun has been archived