SQL Transformations and Ranking | Dataford Interview Questions

Clustering key , partition, 2 questions on sql, 1 was correct I used limit to take out top 3 rows and also told we can use dense_rank to tackle duplicate interviewer not convinced,1 approach was thou I was writing in notepad , questions on dense rank , rank basic , questions on transformation wide and narrow

Write a SQL query to return the top 3 scores from the dataset, including ties at the cutoff. Rows with a NULL score are ignored.

Output

One row per qualifying record, with employee_name, score, and score_rank
Include only rows whose score is in the top 3 ranks after ignoring NULL scores
Sort by score descending, then employee_name ascending

Schema

employee_scores

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
score	INT	Score used for ranking

Your question is SQL Transformations and Ranking. 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.

Problem

Write a SQL query to return the top 3 scores from the dataset, including ties at the cutoff. Rows with a NULL score are ignored.

Output

One row per qualifying record, with employee_name, score, and score_rank
Include only rows whose score is in the top 3 ranks after ignoring NULL scores
Sort by score descending, then employee_name ascending

Schema

employee_scores

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
score	INT	Score used for ranking

Your question is SQL Transformations and Ranking. 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.