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".
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
SELECT DISTINCT fmea_category.
Concepts
SELECT DISTINCT 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