Last 3 Students Query | Dataford Interview Questions

Write a query to find the last 3 students from a student table.

Asked in the Technical interview 1 stage. For this exercise, interpret "last" as the three most recently enrolled students.

Output

Return student_id, student_name, and enrolled_at.
Include only students with a non-null enrollment date.
Return three rows, ordered from most recent enrollment to oldest. Break enrollment-date ties with the higher student_id first.

students

Column	Type	Description
student_idPK	INT	Unique student identifier
student_name	VARCHAR(100)	Student's full name
enrolled_at	DATE	Date when the student enrolled

Your question is Last 3 Students Query. Start with the requirements and the one table 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.

Write a query to find the last 3 students from a student table.

Asked in the Technical interview 1 stage. For this exercise, interpret "last" as the three most recently enrolled students.

Return student_id, student_name, and enrolled_at.
Include only students with a non-null enrollment date.
Return three rows, ordered from most recent enrollment to oldest. Break enrollment-date ties with the higher student_id first.

students

Column	Type	Description
student_idPK	INT	Unique student identifier
student_name	VARCHAR(100)	Student's full name
enrolled_at	DATE	Date when the student enrolled

Your question is Last 3 Students Query. Start with the requirements and the one table 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.