t.SIGNERS[0] AS LIQUIDATOR,

SUM(CASE WHEN t.SUCCEEDED THEN 1 ELSE 0 END) AS SUCCESS_COUNT,

SUM(CASE WHEN t.SUCCEEDED THEN 0 ELSE 1 END) AS ERROR_COUNT,

COUNT(*) AS TOTAL_COUNT,

ROUND(100.0 * SUM(CASE WHEN t.SUCCEEDED THEN 1 ELSE 0 END) / COUNT(*), 2) AS SUCCESS_PERCENT

FROM solana.core.fact_transactions t

WHERE t.BLOCK_TIMESTAMP >= CURRENT_DATE - 5

AND ARRAY_TO_STRING(t.ACCOUNT_KEYS, ',') LIKE '%So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo%'

AND ARRAY_TO_STRING(t.LOG_MESSAGES, ',') LIKE '%iquidate%'

GROUP BY t.SIGNERS[0]

ORDER BY SUCCESS_COUNT DESC

LIMIT 500;