Overall payment-success summary (ClickHouse)

Overall payment-success summary (ClickHouse)

Over the whole payments table, return a single row with: total = count(), successes = rows with status = 'success', success_revenue = sum of amount over successful rows, and success_rate = successes / total rounded to 4 decimals. The whole-table count() denominator is always > 0. Columns: total, successes, success_revenue, success_rate.

Expected output sample

totalsuccessessuccess_revenuesuccess_rate
961010.000.6667
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid