Tell me about how you would approach a technical assessment in SQL to solve a data problem.
For the hands-on portion, use the provided assessments and assessment_submissions tables. Write a query that reports activity during the first quarter of 2025, including assessments with no qualifying submissions.
assessment_name, submission_count, passed_count, pass_rate, and latest_submission_at.assessment_name ascending, then assessment_id ascending for ties.| Column | Type | Description |
|---|---|---|
| assessment_idPK | INT | Unique assessment identifier |
| assessment_name | VARCHAR(100) | Assessment name |
| owner_team | VARCHAR(80) | Team responsible for the assessment |
| Column | Type | Description |
|---|---|---|
| submission_idPK | INT | Unique submission identifier |
| assessment_id | INT | Assessment associated with the submission |
| candidate_id | VARCHAR(40) | Candidate identifier |
| submitted_at | TIMESTAMPTZ | Submission timestamp |
| score | NUMERIC(5,2) | Numeric assessment score |
| result | VARCHAR(20) | Submission result, such as PASS or FAIL |