SQL Quest › SQL Interview Questions › Querying Basics
All Failure Mode Reference
List every failure mode in the lookup with code, name, fmea_category, description. Order by fmea_category, then code.
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".
Schema
failure_modes
| code | name | fmea_category | description |
|---|---|---|---|
| TWF | Tool Wear Failure | Mechanical | Tool wear exceeded threshold (~200 minutes) |
| HDF | Heat Dissipation Failure | Thermal | Air-process temperature differential too low + high rotational speed |
| PWF | Power Failure | Electrical | Required process power outside [3500, 9000] W envelope |
Expected output: All 5 modes with descriptions
Hint
Just SELECT * with an ORDER BY.
Concepts
SELECT ORDER BY
Practise the topic: SQL practice questions
Related questions
Your First QueryEasy · FreePick Your ColumnsEasy · FreeFilter with WHEREEasy · FreeComparison OperatorsEasy · FreeMultiple Conditions (AND / OR)Easy · FreeThe IN OperatorEasy · 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