Skip to main content
All Problems
easy0% acceptance

Out-of-Stock Products

The warehouse manager needs to know which products are running low. List the product name, category_id, and stock_quantity for every product where stock_quantity is less than 10, sorted by stock_quantity ascending, then by name.

Schema

🔑idINT
nameTEXT
🔗category_idINT
priceREAL
costREAL
stock_quantityINT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute