from(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, event_contract,count(*)

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)

group by 1