Apply a +10% price bump on paid orders
Finance decided to index prices by 10% — every paid order (status = 'paid') gets its amount multiplied by 1.1. Don't touch cancelled orders. A single UPDATE covers the whole table — do the arithmetic right in the assignment, no separate reads.
Just INSERT/UPDATE/DELETE — no trailing SELECT needed.
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid