-- спортсмены
create table t_athletes
(
    id number,
    name varchar(100)
);

-- судьи
create table t_referees
(
    id number,
    name varchar(100)
);

-- оценки
create table t_rating
(
    athlete_id number,
    referee_id number,
    val number
);

insert into t_athletes values (1, 'Smith');
insert into t_athletes values (2, 'Jones');
insert into t_athletes values (3, 'Davis');

insert into t_referees values (100, 'Ref Scott');
insert into t_referees values (200, 'Ref Tiger');

insert into t_rating values (1, 100, 2);
insert into t_rating values (1, 200, 5);

insert into t_rating values (2, 100, 5);
insert into t_rating values (2, 200, 4);

insert into t_rating values (3, 100, 1);
insert into t_rating values (3, 200, 3);

        | Ref Scott | Ref Tiger
--------+-----------+----------
Smith   |         2 |         5
Jones   |         5 |         4
Davis   |         1 |         3

select 
    ah.name, /*
    max(decode(re.id, 100, ra.val, 0)) "Ref Scott",
    ... колонки формируем динамически
    */
from t_athletes ah
inner join t_rating ra   on ra.athlete_id = ah.id
inner join t_referees re on re.id = ra.referee_id
group by ah.id, ah.name