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?

A

3, 3, 3

B

3, 3, 2

C

3, 2, 2

D

2, 2, 2