Easy
WHERE
Products with Limited Stock
Find products with fewer than 200 units in stock, cheapest first. Return columns: name, category, price, stock. Order results by: price.
Preparing the interactive SQL workspace...
Challenge overview
What you will practice
Find products with fewer than 200 units in stock, cheapest first. Return columns: name, category, price, stock. Order results by: price.
- Difficulty
- Beginner
- SQL concept
- WHERE
Public schema and sample data
customers
| id INTEGER | name TEXT | email TEXT | country TEXT | joined_date TEXT |
|---|---|---|---|---|
| 1 | Acme Corp | acme@corp.com | USA | 2020-01-15 |
| 2 | TechStart Ltd | ts@techstart.io | UK | 2020-03-22 |
| 3 | DataFlow Inc | info@dataflow.com | USA | 2021-06-10 |
products
| id INTEGER | name TEXT | category TEXT | price REAL | stock INTEGER |
|---|---|---|---|---|
| 1 | Analytics Dashboard | Software | 299 | 999 |
| 2 | Data Warehouse | Infrastructure | 1499 | 50 |
| 3 | ML Pipeline | Software | 799 | 999 |
orders
| id INTEGER | customer_id INTEGER | order_date TEXT | total_amount REAL | status TEXT |
|---|---|---|---|---|
| 1 | 1 | 2024-01-10 | 2697 | completed |
| 2 | 2 | 2024-01-15 | 799 | completed |
| 3 | 1 | 2024-02-01 | 1499 | completed |
order_items
| id INTEGER | order_id INTEGER | product_id INTEGER | quantity INTEGER | unit_price REAL |
|---|---|---|---|---|
| 1 | 1 | 1 | 3 | 299 |
| 2 | 1 | 4 | 8 | 99 |
| 3 | 2 | 3 | 1 | 799 |