Faults in the Sensor Log
Faults in the Sensor Log
The recorder wrote free text into note, but fault codes share one shape: the letter E plus digits after code=. Output reading_id, station and note for readings whose note carries such a fault code — matched with a regular expression, not a substring. Order by reading_id.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| reading_id | station | note |
|---|---|---|
| 2 | Reactor-A | fault code=E42; retry scheduled |
| 3 | Reactor-B | fault code=E7; manual check |
| 5 | Dome-Air | fault code=E401; replace filter |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid