Use a defined database structure and business rules to query products, warehouses, stock levels, and stock movements. It supports inventory checks and SQL for identifying products whose combined warehouse stock has reached the reorder threshold.
中文简介正在准备中。当前显示英语简介。
Database schema and business logic for inventory tracking including products, warehouses, and stock levels.
安装前可以查看交给 AI 代理的指令内容。
Available stock: quantity_on_hand from inventory where quantity_on_hand > 0
Products needing reorder: total quantity_on_hand across warehouses <= product's reorder_point
Active products only: Exclude discontinued = true unless analyzing discontinued items
-- Find products below reorder point
SELECT p.product_id, p.product_name, p.reorder_point, SUM(i.quantity_on_hand) as total_stock
FROM products p
JOIN inventory i ON p.product_id = i.product_id
WHERE p.discontinued = false
GROUP BY p.product_id, p.product_name, p.reorder_point
HAVING SUM(i.quantity_on_hand) <= p.reorder_point;
还没有评价。欢迎分享你的使用感受。
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
Use defined customer and order tables to build sales analysis queries with consistent business rules. Calculate revenue from completed orders, rank customers by spending, and identify high-value orders using the supplied thresholds and SQL example.
中文简介正在准备中。当前显示英语简介。