Low Stock Products - Easy SQL Filtering Interview Problem

Problem

Walmart's warehouse team needs to know about any product with a stock quantity under 10 units before it hits zero. Using the products table, return id, name, and stock_quantity for all products with fewer than 10 units in stock, ordered by stock_quantity ascending.

Schema

products

column	type
id	INTEGER
name	TEXT
category	TEXT
price	NUMERIC
stock_quantity	INTEGER

Sample Data

id	name	stock_quantity
1	Widget	3
2	Gadget	15
3	Doohickey	0
4	Thingamajig	7

Expected Output

id	name	stock_quantity
3	Doohickey	0
1	Widget	3
4	Thingamajig	7

Hints