mu-tafaUntitled Query
Updated 2022-07-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (
SELECT
date_trunc(day,block_timestamp) as date,
proposer as users
from flow.core.fact_transactions
where date BETWEEN '2022-05-1' and '2022-05-30' ),
tab2 as (
SELECT
proposer as users,
tx_id as tx_count,
date_trunc(day,block_timestamp) as date
from flow.core.fact_transactions
where date between '2022-06-1' and '2022-06-30' )
SELECT
count(b.tx_count) as transaction_count,
b.date
from tab1 a left join tab2 b on a.users=b.users
group by b.date
Run a query to Download Data