Idle SKUs

Today is 2026-09-01. Return SKUs with no movement in the last 30 days (last move before 2026-08-02), with the date of their last movement. Order by SKU.

Table schema

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

Sample data

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