Failed UPI and card payments clutter the payments report. Delete the payments
whose status is failed and whose method is upi or card. Payments made any other way
stay, even when they failed.
Then show payment_id, method and status of every payment whose status is not
success.
End your query with ORDER BY payment_id.
| payments |
|---|
| payment_id (PK) |
| order_id (FK) |
| customer_id (FK) |
| amount |
| method |
| status |
| paid_at |
Failed UPI and card payments clutter the payments report. Delete the payments
whose status is failed and whose method is upi or card. Payments made any other way
stay, even when they failed.
Then show payment_id, method and status of every payment whose status is not
success.
End your query with ORDER BY payment_id.
| payments |
|---|
| payment_id (PK) |
| order_id (FK) |
| customer_id (FK) |
| amount |
| method |
| status |
| paid_at |
| payment_id | method | status |
|---|---|---|
| 5 | cod | pending |
| 7 | wallet | refunded |
| 10 | upi | refunded |
| 12 | cod | pending |
| 16 | cod | pending |
| 17 | cod | failed |
| 20 | cod | refunded |
| 27 | netbanking | pending |
| 29 | wallet | pending |
| 30 | wallet | pending |
| 31 | netbanking | failed |
| 35 | wallet | pending |
| 36 | card | refunded |
| 44 | cod | refunded |
| 46 | cod | pending |
| 55 | cod | failed |
| 57 | cod | refunded |
| 60 | wallet | refunded |
| 61 | cod | refunded |
| 63 | cod | refunded |
| 65 | card | refunded |
| 67 | cod | refunded |
| 70 | cod | refunded |
| 71 | card | refunded |
| 77 | netbanking | pending |
| 78 | upi | refunded |
| 85 | netbanking | refunded |
| 90 | card | refunded |
| 92 | cod | refunded |
| 95 | card | refunded |
| 99 | wallet | refunded |
| 106 | netbanking | refunded |
| 107 | card | refunded |
| 108 | upi | refunded |
| 109 | upi | pending |
| 110 | cod | refunded |
| 112 | cod | pending |
| 113 | card | refunded |
| 116 | card | refunded |
| 125 | upi | refunded |
| 130 | upi | refunded |
| 132 | wallet | refunded |
| 133 | netbanking | refunded |
| 134 | netbanking | pending |
| 136 | card | pending |
| 138 | wallet | pending |
| 141 | cod | pending |
| 144 | netbanking | failed |
| 150 | netbanking | pending |
| 152 | upi | refunded |
| 153 | card | refunded |
| 154 | upi | pending |
| 155 | wallet | pending |
| 156 | netbanking | pending |
| 157 | wallet | pending |
| 160 | netbanking | pending |
| 162 | netbanking | refunded |
| 163 | upi | refunded |
| 164 | card | refunded |
| 165 | upi | pending |
| 170 | netbanking | pending |
| 173 | cod | refunded |
| 176 | card | pending |
| 177 | netbanking | refunded |
| 182 | cod | refunded |
| 184 | netbanking | refunded |
| 185 | card | pending |
| 186 | card | pending |
| 193 | upi | pending |
| 194 | netbanking | pending |
| 197 | cod | refunded |
| 198 | netbanking | refunded |
| 200 | upi | refunded |
| 204 | wallet | pending |
| 205 | card | refunded |
| 207 | upi | refunded |
| 208 | card | refunded |
| 211 | netbanking | refunded |
| 212 | netbanking | refunded |
| 216 | card | refunded |
| 218 | cod | failed |
| 219 | upi | pending |
| 222 | upi | pending |
| 223 | cod | pending |
| 225 | wallet | failed |
| 226 | upi | refunded |
| 227 | wallet | refunded |
| 233 | upi | pending |
| 234 | wallet | failed |
| 237 | upi | refunded |
| 239 | netbanking | pending |
| 241 | wallet | refunded |
| 244 | card | pending |
| 247 | wallet | failed |
| 249 | cod | refunded |
| 250 | cod | refunded |
| 257 | netbanking | failed |
| 258 | card | pending |
| 263 | wallet | pending |
| 264 | card | refunded |
| 265 | card | refunded |
| 266 | upi | pending |
| 268 | netbanking | pending |
| 271 | wallet | pending |
| 273 | wallet | refunded |
| 274 | wallet | refunded |
| 277 | wallet | refunded |
| 279 | wallet | failed |
| 280 | upi | refunded |
| 281 | netbanking | failed |
| 282 | wallet | pending |
| 286 | wallet | refunded |
| 287 | upi | refunded |
| 288 | cod | failed |
| 289 | wallet | pending |
| 293 | card | pending |
| 295 | upi | refunded |
| 296 | wallet | refunded |
| 297 | card | refunded |
| 301 | wallet | refunded |
| 303 | wallet | refunded |
| 308 | upi | refunded |
| 313 | netbanking | failed |
| 314 | cod | failed |
Run query to see output