Stock report

Write the UPDATE query that recomputes stock level.

Updating stock

To change the stock quantity you use UPDATE. qty is updated after a sale or a delivery.

UPDATE inventory
SET qty = qty - 5
WHERE id = 1;

This query removes 5 from product 1.

In inventory, qty = qty - 5 is updated. Only the rows where id = 1 holds are affected.

SET qty = qty - 5 subtracts 5 from the old quantity. This is the standard way to reduce stock after a sale.

Reduce qty by 5 for id=1 in inventory.

Show example solution

UPDATE inventory
SET qty = qty - 5
WHERE id = 1

Reduce quantity

UPDATE inventory
SET qty = qty ____ 5
WHERE id = 1;

Show answer

UPDATE inventory
SET qty = qty - 5
WHERE id = 1;