What does the NTILE(4) OVER (ORDER BY score DESC) assign to a row ranked 3rd out of 20?

Question

SQL Data Analyst — Medium

What does the NTILE(4) OVER (ORDER BY score DESC) assign to a row ranked 3rd out of 20?

Accepted Answer

The NTILE(4) function divides the data into 4 equal parts. Since the row is ranked 3rd out of 20, it falls in the top quartile, which includes positions 1-5 of 20.