Top 10 Students by GPA SQL | Dataford Interview Questions

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.

Output

One row per student, with columns student_id, student_name, and gpa.
Include at most 10 students, ordered by gpa descending and student_id ascending for ties.

students

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

Your question is Top 10 Students by GPA SQL. Start with the requirements and the one table in the Question tab.

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.

One row per student, with columns student_id, student_name, and gpa.
Include at most 10 students, ordered by gpa descending and student_id ascending for ties.

students

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

Your question is Top 10 Students by GPA SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.