Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started
SQL for Top GPA Improvers
00:00
5 left

SQL for Top GPA Improvers

MediumSQL · PostgreSQL

Problem

Write a SQL query to find the top 5% of students based on their GPA improvement over the last three semesters at the University of Georgia.

Use the students and student_gpa_progress tables. Include only students with GPA values for all three semesters. For a fractional 5% cutoff, return at least one student and use student ID as the deterministic tie-breaker.

Output

  1. One row per qualifying student, with student_id, student_name, starting_gpa, ending_gpa, and gpa_improvement.
  2. Include only the top 5% by improvement, ordered by gpa_improvement descending and student_id ascending.

Schema

students
ColumnTypeDescription
student_idPKINTUnique University of Georgia student identifier
student_nameVARCHAR(100)Student's full name
student_gpa_progress
ColumnTypeDescription
student_idPKINTStudent identifier associated with the GPA record
fall_2024_gpaNUMERIC(3,2)GPA for the first of the three semesters
spring_2025_gpaNUMERIC(3,2)GPA for the second of the three semesters
fall_2025_gpaNUMERIC(3,2)GPA for the latest semester
Tablesstudentsstudent_gpa_progress
Interviewer

Your question is SQL for Top GPA Improvers. Start with the requirements and the two tables 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.

You need to log in / sign up to run or submit.
CodePostgreSQL
You need to log in / sign up to run or submit.Ln 1
Run your query to see results here.