Your question is Top 10 Students by GPA SQL. 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.
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 |