create table t1 (id int, first_name varchar(100), last_name varchar(100), score double);

create index t1_name on t1 (first_name, last_name);

insert into t1 values

(1, 'Alice', 'Fowler', 5),

(2, 'John', 'Doe', 6),

(3, 'John', 'Smith', 6),

(4, 'John', 'Smith', 6),

(5, 'John', 'Smith', 7),

(6, 'John', 'Elton', 8.1),

(7, 'Bob',  'Trasc', 9),

(8, 'Silvia', 'Ganush', 10);

select first_name fn, last_name ln, row_number() over () rn

from t1

order by rn desc;

fn	ln	rn

Alice	Fowler	1

Bob	Trasc	2

John	Smith	3

John	Smith	4

John	Smith	5

John	Elton	6

John	Doe	7

Silvia	Ganush	8