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.
Requirements
- Filter results to the
QA Automation assessment and exclude NULL marks.
- Rank distinct mark values from highest to lowest using a window function.
- Join the marks to
students and return the student ID, name, assessment name, marks, and rank.
- Sort by marks descending, then student ID ascending.
