Your question is Identify Records With Invalid or Unexpected Status Values. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
The Apex Systems QA defect tracker requires every defect to use an approved workflow status. Write a PostgreSQL query to identify records whose status is invalid, unexpected, empty, or missing.
defect_id, status, and summary for every record whose status is not one of new, in_progress, resolved, or closed, including NULL values.defect_id in ascending order.| Column | Type | Description |
|---|---|---|
| defect_idPK | INT | Unique defect identifier |
| status | VARCHAR(30) | Current defect workflow status |
| summary | VARCHAR(200) | Short description of the defect |
| created_at | DATE | Date the defect was created |