select

event_contract,

count(*) as popularity

from flow.core.fact_events

where block_timestamp::date >= '2022-05-09'

and exists (select tx_id from flow.core.fact_transactions where TX_SUCCEEDED = 1 and flow.core.fact_events.tx_id = flow.core.fact_transactions.tx_id)

group by event_contract

order by popularity DESC

limit 10

select

COALESCE(contract_name, e.event_contract) AS Name,

count(*) as popularity_per_day

from flow.core.fact_events e

left join flow.core.dim_contract_labels f ON e.event_contract = f.event_contract

where block_timestamp::date >= '2022-05-09'

and e.event_contract in (select event_contract from list)

group by Name

order by popularity_per_day desc

--*,

--TRANSACTION_RESULT:events[0]:value