Second Highest Marks SQL | Dataford Interview Questions

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.

Requirements

Consider only active students and non-null marks for the specified assessment.
Treat tied marks as one rank, so every student sharing the second highest distinct mark must be returned.
Return student_id, student_name, and marks, ordered by marks descending and then student name ascending.

Schema

students

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

assessment_scores

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

Your question is Second Highest Marks SQL. 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.

Problem