QQueryU
Your first SQL query

Your first query: find the five highest-GPA students.

The join, the filter and the average are written for you. Sorting and keeping the top five is your part, the same shape most real questions take.

  1. Readthe prompt
  2. Trya query
  3. Submitto pass
Warm-up · Easy

Find the top 5 students by GPA

Return the five highest-GPA students in Fall 2024, ordered by GPA descending. Show the student name and their GPA (averaged across all their Fall 2024 grades, rounded to two decimal places).

top_students.sql

Write PostgreSQL. Press Command or Control plus Enter to run.