distinct EVENT_CONTRACT,

EVENT_TYPE,

count(distinct tx_id) as no_fail

from flow.core.fact_events

where TX_SUCCEEDED='FALSE'

group by 1,2

order by 3 desc