Filter Students by Subject and Grade | Dataford Interview Questions

Your question is Filter Students by Subject and Grade. Start with the requirements and the three 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.

Problem

Adobe Digital Academy tracks student performance across technical subjects. Write a PostgreSQL query that finds students enrolled in Adobe Analytics who earned a grade of at least 85.

Requirements

Join students, grades, and subjects using their key relationships.
Filter for the exact subject name Adobe Analytics and grades greater than or equal to 85.
Return the student ID, student name, subject name, and numeric grade.
Sort results by grade descending, then student name ascending. Rows with no grade must not qualify.

Schema

students

Column	Type	Description
student_idPK	INT	Unique student identifier
student_name	VARCHAR(100)	Student's full name
email	VARCHAR(255)	Student email address

subjects

Column	Type	Description
subject_idPK	INT	Unique subject identifier
subject_name	VARCHAR(150)	Subject title

grades

Column	Type	Description
grade_idPK	INT	Unique grade record identifier
student_id	INT	Referenced student
subject_id	INT	Referenced subject
grade	INT	Numeric grade from 0 to 100