Skip to main content
All Problems
easy0% acceptance

Products Never Ordered

The inventory team wants to identify slow-moving products. Find all products that have been ordered fewer than 3 times. Return the product name, price, and order_count. Sort by order_count 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