SQL Quest › SQL Interview Questions › Querying Basics
Distinct FMEA Categories
FMEA (Failure Mode and Effects Analysis) groups failures by physical cause type. List distinct fmea_category values from the failure_modes lookup table. Order alphabetically.
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: Categories like Mechanical, Thermal, Electrical, Stochastic
Hint
Concepts
SELECT DISTINCT ORDER BY
Practise the topic: SQL practice questions
Read the concept: Practice SQL with no setup
Related questions
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