Describe how you would approach a multi-step Excel and programming assessment to produce an accurate result.
Use the provided assessment tables to produce an auditable SQL result. Treat a submission as accurate only when it is submitted, contains both required steps, has no missing step results, has no failed validation checks, and has steps completed in chronological order.
candidate_id, completed_steps, failed_checks, missing_values, out_of_order_steps, accuracy_status, and duration_minutes.submission_id ascending.| Column | Type | Description |
|---|---|---|
| submission_idPK | INT | Unique assessment submission identifier |
| candidate_id | VARCHAR(30) | Candidate identifier |
| submitted_at | TIMESTAMP | Time the assessment was submitted |
| status | VARCHAR(20) | Submission state |
| Column | Type | Description |
|---|---|---|
| step_idPK | INT | Unique step result identifier |
| submission_id | INT | Related assessment submission |
| step_number | INT | Sequential step number |
| step_name | VARCHAR(50) | Name of the assessment step |
| result_value | DECIMAL(10,2) | Recorded step result |
| expected_value | DECIMAL(10,2) | Reference result for comparison |
| completed_at | TIMESTAMP | Time the step was completed |
| Column | Type | Description |
|---|---|---|
| check_idPK | INT | Unique validation check identifier |
| submission_id | INT | Related assessment submission |
| step_id | INT | Related step, when applicable |
| check_type | VARCHAR(40) | Validation category |
| check_status | VARCHAR(20) | Validation outcome |
| checked_at | TIMESTAMP | Time of validation |