signers[0] as signer

, count(1) as "User Total Txs"

, count_if(succeeded) as "Successful Txs"

, count_if(not succeeded) as "Failed Txs"

, round(100 * "Failed Txs" / "User Total Txs", 2) as "User Tx Failure Ratio"

, any_value(tx_id)

from solana.core.fact_events

where 1 = 1

and block_timestamp::date = '2024-08-12'

and program_id = 'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4'

group by all

having "User Total Txs" > 20

order by "User Tx Failure Ratio" desc

limit 100