Successful revenue by method (ClickHouse)

In payments, for each method compute revenue — the sum of amount over rows with status = 'success' only (failed/refunded are excluded). Use sumIf. Order by method. Columns: method, revenue.