Write a SQL query to extract the top 10 students by GPA from a database.
Use the students table. Include only students with a recorded GPA and return the highest GPAs first. Break GPA ties by ascending student_id.
student_id, student_name, and gpa.gpa descending and student_id ascending for ties.| Column | Type | Description |
|---|---|---|
| student_idPK | INT | Unique identifier for the student |
| student_name | VARCHAR(100) | Full name of the student |
| gpa | NUMERIC(3,2) | Cumulative grade point average |