SQL Quest › SQL Interview Questions › Querying Basics
Medium Quality Products
Find products whose product_id starts with 'M' (medium-quality). Show product_id, type, tool_wear_min sorted by product_id ascending. Top 15.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect". Free accounts get 10 free challenge solves, and this can be one of them.
Schema
products
| udi | product_id | type | tool_wear_min |
|---|---|---|---|
| 5640 | L52819 | L | 180 |
| 2171 | M17030 | M | 10 |
| 228 | L47407 | L | 168 |
Expected output: M-grade product list
Hint
WHERE product_id LIKE 'M%'.
Concepts
SELECT WHERE LIKE
Practise the topic: SQL practice questions
Read the concept: Practice SQL with no setup
Related questions
High-Quality Products OnlyEasy · FreeDistinct FMEA CategoriesEasy · FreeAll Failure Mode ReferenceEasy · FreeGive the Top Performers a RaiseMedium · FreeYour First QueryEasy · FreePick Your ColumnsEasy · Free
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test