with xt as (
select 'John','Silver','Swimming' from dual
union
select 'Steve','Bronze','Hockey' from dual
union
select 'Smith','Silver','Hockey' from dual
union
select 'X','Gold','Swimming' from dual
union
select 'Pudzianowski','Silver','Judo' from dual
union
select 'Kom','Bronze','Judo' from dual
union
select 'X','Gold','Hockey' from dual
union
select 'Gabriel','Bronze','Swimming' from dual
union
select 'X','Gold','Judo' from dual)
select * from xt;
with above data, i would like to list all the athletes medal wise something like this
Gold Silver Bronze
X Pudzianowski Kom
X John Steve
X Smith Gabriel