feyikemizany-sapphire
Updated 2024-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
DISTINCT Label_type AS Sector
FROM flow.core.dim_labels
WHERE
block_timestamp::DATE >= '2024-01-01'
-- SELECT
-- Label_type as Sector,
-- COUNT(DISTINCT Authorizers[0]) As Users,
-- COUNT(DISTINCT Tx_id) As Txns,
-- FROM
-- flow.core.fact_transactions a
-- LEFT JOIN flow.core.dim_labels b
-- ON a.Proposer = b.address
-- WHERE
-- block_timestamp::DATE >= '2024-01-01'
-- AND Sector IS NOT NULL
-- --AND block_timestamp::DATE < '2024-08-01'
-- GROUP BY 1
-- ORDER BY 2 DESC
QueryRunArchived: QueryRun has been archived