hbd1994Contracts and the Number of Uses of Them
Updated 2022-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with top as (Select distinct top 10 fact_events.EVENT_CONTRACT as "Contract", dim_contract_labels.CONTRACT_NAME as "Contract Name" ,
count(fact_events.*) as "Number of Use"
from flow.core.fact_events
full join flow.core.dim_contract_labels on dim_contract_labels.EVENT_CONTRACT=fact_events.EVENT_CONTRACT
where fact_events.TX_SUCCEEDED = 'TRUE'
and fact_events.block_timestamp >= '2022-05-09'
group by 1 , 2
order by 3 desc)
select distinct event_type as "Application Type", event_contract as "Contract", count(*) as "Number of Uses"
from flow.core.fact_events
inner join top on top."Contract"=fact_events.event_contract
where fact_events.block_timestamp >= '2022-05-09'
group by 1 , 2
Run a query to Download Data