feyikemiAll Time
Updated 2025-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH total_stats AS (
SELECT
count(distinct from_address) AS active_users,
count(distinct tx_hash) AS transactions
FROM
kaia.core.fact_transactions
WHERE tx_succeeded = 'True'
)
SELECT
Active_users AS Total_Users,
Transactions AS Total_Txns
FROM total_stats
QueryRunArchived: QueryRun has been archived