Yousefi_1994How many ShroomDK NFTs have been minted so far?
Updated 2022-07-02
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
›
⌄
with total_mint as (
select
count(distinct tx_hash) as number_of_mint
from ethereum.core.fact_transactions
where to_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
and origin_function_signature = '0x2b1ccc9a'
),
success_mint as (
select
count(distinct tx_hash) as number_of_mint
from ethereum.core.fact_transactions
where to_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
and origin_function_signature = '0x2b1ccc9a'
and status = 'SUCCESS'
),
fail_mint as (
select
count(distinct tx_hash) as number_of_mint
from ethereum.core.fact_transactions
where to_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
and origin_function_signature = '0x2b1ccc9a'
and status = 'FAIL'
)
select 'Total mint' as type, * from total_mint
union
select 'Success mint' as type, * from success_mint
union
select 'Fail mint' as type, * from fail_mint
Run a query to Download Data