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". Free accounts get 10 free challenge solves, and this can be one of them.
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
Read the concept: Learn SQL for beginners
Related questions
Top 10 by Tool WearEasy · FreeHigh-Quality Products OnlyEasy · FreeDistinct FMEA CategoriesEasy · FreeMedium Quality ProductsEasy · FreeGive the Top Performers a RaiseMedium · FreeYour First QueryEasy · 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