Current Stock per SKU

Stock = quantity received (IN) minus quantity shipped (OUT). Return each SKU with its current stock, ordered 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