SKUs Below Reorder Level

Return SKUs whose current stock is below their reorder level, with stock and level. Order by SKU.

Table schema

StockMoves(id INT PRIMARY KEY, sku VARCHAR(5), qty INT, move_type VARCHAR(3), move_date DATE)
Reorder(sku VARCHAR(5) PRIMARY KEY, level INT)

Sample data

StockMoves
id | sku | qty | move_type | move_date
1 | A1 | 100 | IN | 2026-08-01
2 | A1 | 30 | OUT | 2026-08-05
3 | B2 | 50 | IN | 2026-08-02
4 | B2 | 45 | OUT | 2026-08-10
5 | A1 | 20 | OUT | 2026-08-20
6 | C3 | 10 | IN | 2026-06-01

Reorder
sku | level
A1 | 40
B2 | 10
C3 | 5