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 |