Move Money Between Wallets
EasyDescription
Customer 4 sends ₹2,500 to customer 9. In one transaction, take the money out of customer 4's wallet and put it into customer 9's wallet, then commit.
Then show customer_id and balance of both wallets.
End your query with ORDER BY customer_id.
Tables
| accounts |
|---|
| account_id (PK) |
| customer_id (FK) |
| account_no |
| balance |
| opened_at |