Third Or Second Place
scores:
| player | pts |
|---|---|
| ana | 90 |
| bo | 90 |
| cy | 85 |
| dee | 70 |
SELECT player, pts,
row_number() OVER w AS rn,
rank() OVER w AS rk,
dense_rank() OVER w AS dr
FROM scores
WINDOW w AS (ORDER BY pts DESC);
What are rn, rk and dr on cy's row?
Sign in to answer questions and track your progress
Sign In