logo

Oracle NextGen

score

SQL Challenge

Challenge #6 – Top Scoring Students

MediumGo Back
Challenge Overview
Report the students who scored 90 or above in the most recent algorithm exam. Provide their identifiers, names, and scores ranked from highest to lowest.

Requirements

  • •Return columns: student_id, student_name, score.
  • •Filter for scores greater than or equal to 90.
  • •Order results by score in descending order, breaking ties alphabetically by student_name.
  • •Assume exam_date represents the exam these scores belong to.
Sample Dataset
Preview the schema and seeded rows you can query against.

students

Holds the latest exam submission per student.

Columns
NameTypeNotes
student_idINTPrimary key
student_nameVARCHARFull name
scoreINTExam score (0-100)
exam_dateDATESubmission date
Sample Rows
student_idstudent_namescoreexam_date
101Amina Chen982024-09-14
102Leo Nunez872024-09-14
103Priya Patel952024-09-15
104Noah Smith912024-09-15
105Sara Lopez882024-09-16
SQL Playground
Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.