b.address_name as program,

count(a.tx_id) as failed_txns,

sum(a.fee) as total_fees

FROM solana.core.fact_transactions a

join solana.core.dim_labels b

on a.instructions[0] : programId = b.address

WHERE

a.block_timestamp >= '2022-01-01'

and a.succeeded = false

GROUP BY program order by total_fees desc

limit 10