Your question is Writing SQL Queries. 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.
Curriculum Associates needs a quick extract from i-Ready Diagnostic results for reviewing strong Spring 2025 performance. Write a PostgreSQL query using only the iready_diagnostic_results table.
administration is Spring 2025 and whose diagnostic_score is at least 500.diagnostic_score descending, then by student_id ascending to make ties deterministic.| Column | Type | Description |
|---|---|---|
| student_id | INT | Student identifier |
| student_name | VARCHAR(100) | Student name |
| school_name | VARCHAR(100) | School name |
| administration | VARCHAR(30) | i-Ready Diagnostic administration period |
| diagnostic_score | INT | Overall diagnostic scale score |
| assessment_date | DATE | Date the assessment was completed |