Your question is Second Highest Marks SQL. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
TraceLink Opus tracks student results for internal onboarding assessments. Write a PostgreSQL query to find the students who achieved the second highest distinct mark on the TraceLink Opus Onboarding assessment.
student_id, student_name, and marks, ordered by marks descending and then student name ascending.| Column | Type | Description |
|---|---|---|
| student_idPK | INT | Unique student identifier |
| student_name | VARCHAR(100) | Student's full name |
| is_active | BOOLEAN | Whether the student is currently active |
| Column | Type | Description |
|---|---|---|
| score_idPK | INT | Unique score identifier |
| student_id | INT | References students.student_id |
| assessment_name | VARCHAR(150) | Name of the assessment |
| marks | INT | Marks earned, from 0 to 100 |