Low stock alert

Write queries that list low stock and clean up records.

Removing items

To remove a product from inventory you use DELETE. Discontinued products are deleted.

DELETE FROM inventory
WHERE id = 3;

This query removes product 3 from the inventory.

Rows are deleted from inventory. Only the rows where id = 3 holds are affected.

Deletion cannot be undone. Make sure the product really should be removed. Always include WHERE.

Delete the product with id=3 from inventory.

Show example solution

DELETE FROM inventory
WHERE id = 3

Delete row

DELETE ____ inventory
WHERE id = 3;

Show answer

DELETE FROM inventory
WHERE id = 3;