SQL Practice Logo

SQLPractice Online

Level 1 - BeginnerScenario-Based Questions

Scenario: Inventory Reorder List

A store team needs products that must be reordered today. Schema: products(id, name, stock_qty, reorder_level) Write SQL to list product id and name where stock_qty is below reorder_level, ordered by stock_qty ascending.