#1050

Failed Payment Total

Step 2: for the stuck orders from step 1, total the payments with status = 'failed'. Return one row with total; if there are no such payments, total must be 0.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

total
21

Your query result will appear here