SQL interview question: Rows Above the Average
Students Exceeding Average GPA
Academic advisors want to recognize students performing above the school average.
Find all students with a GPA higher than the overall average GPA.
Return student_id, name, and gpa. Order by gpa descending.
Skills: subquery in WHERE clause
Tables
students 25 rows
- student_id integer PK
- name text
- email text
- grade_level integer
- gpa real
- enrollment_date text
| student_id | name | grade_level | gpa | enrollment_date | |
|---|---|---|---|---|---|
| 1 | Alice Johnson | [email protected] | 12 | 3.9 | 2024-09-01 |
| 2 | Bob Smith | [email protected] | 12 | 3.7 | 2024-09-01 |
| 3 | Carol Williams | [email protected] | 12 | 3.8 | 2024-09-01 |