Your question is Top 3 Marks Per Student. 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.
The MakeMyTrip QA team wants to identify the strongest performers in its QA Automation assessment. Write a PostgreSQL query that returns every student whose mark is among the top three distinct marks, including all students tied at those marks.
QA Automation assessment and exclude NULL marks.students and return the student ID, name, assessment name, marks, and rank.| Column | Type | Description |
|---|---|---|
| student_idPK | INT | Unique student identifier |
| student_name | VARCHAR(100) | Student's full name |
| city | VARCHAR(50) | Student's registered city |
| Column | Type | Description |
|---|---|---|
| mark_idPK | INT | Unique mark record identifier |
| student_id | INT | References students.student_id |
| assessment_name | VARCHAR(100) | Name of the assessment |
| marks | INT | Marks earned in the assessment |
| attempt_no | INT | Assessment attempt number |