Stock movements

Write INSERT queries to add new stock.

Querying stock

To query the inventory you use SELECT. You can filter by location or a minimum quantity.

SELECT name, qty
FROM inventory
WHERE qty < 10;

This query lists items with fewer than 10 in stock.

name, qty is selected from inventory. WHERE keeps only the rows where qty < 10 holds.

A low-stock alert uses a qty < threshold query. It tells you when to reorder.

Select name and qty from inventory where qty is less than 10.

Show example solution

SELECT name, qty
FROM inventory
WHERE qty < 10

Filter stock

SELECT name, qty FROM inventory
WHERE ____;

Show answer

SELECT name, qty FROM inventory
WHERE qty < 10;

Next lesson: Stock report