SELECT
signers[0] as user,
count(DISTINCT CASE when SUCCEEDED='true' then tx_id end ) as true_txs,
count(DISTINCT CASE when SUCCEEDED='false' then tx_id end ) as false_txs,
true_txs + false_txs as total_txs
FROM solana.core.fact_events
WHERE program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'
AND block_timestamp::date >= '2023-08-23'
GROUP BY 1
ORDER BY total_txs DESC