BTEQ 15.10.01.01 Mon Feb 05 16:06:51 2018 PID: 21712
 
+---------+---------+---------+---------+---------+---------+---------+----
/***************************** Examples of pivoting and unpivoting data. Uses a subset of the results from the Rio Olympics as a data source. ***************************/

/* Replace the IP address with the IP address of the Vantage database for your site. */
.logon 192.0.2.10/dbc,

 *** Logon successfully completed.
 *** Teradata Database Release is 16.60d.00.05                  
 *** Teradata Database Version is 16.60d.00.05p1                  
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.
 
 *** Total elapsed time was 2 seconds.
 
+---------+---------+---------+---------+---------+---------+---------+----

.errorout stdout
 *** Error messages now directed to STDOUT.
+---------+---------+---------+---------+---------+---------+---------+----
.sidetitles on
+---------+---------+---------+---------+---------+---------+---------+----
.foldline on
+---------+---------+---------+---------+---------+---------+---------+----

delete user pivot_db;
 *** Failure 3802 Database 'pivot_db' does not exist.
                Statement# 1, Info =0 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
drop user pivot_db;
 *** Failure 3802 Database 'pivot_db' does not exist.
                Statement# 1, Info =0 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
create user pivot_db as perm=10e6, password=pivot_db;

 *** User has been created. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

database pivot_db;

 *** New default database accepted. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

create table olympic_medal_winners (   
  olympic_year int,  
  sport        varchar( 30 ),  
  gender       varchar( 1 ),  
  event        varchar( 128 ),  
  medal        varchar( 10 ),  
  noc          varchar( 3 ),  
  athlete      varchar( 128 ) 
);

 *** Table has been created. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Archery','M','Men''s Individual','Gold','KOR','KU
 Bonchan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Archery','M','Men''s Individual','Silver','FRA','
VALLADONT Jean-Charles');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Archery','M','Men''s Individual','Bronze','USA','
ELLISON Brady');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Archery','M','Men''s Team','Gold','KOR','Republic
 of Korea');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Archery','M','Men''s Team','Bronze','AUS','Austra
lia');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Archery','M','Men''s Team','Silver','USA','United
 States');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Artistic Gymnastics','M','Men''s Floor Exercise',
'Gold','GBR','WHITLOCK Max');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Artistic Gymnastics','M','Men''s Floor Exercise',
'Bronze','BRA','MARIANO Arthur');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Artistic Gymnastics','M','Men''s Floor Exercise',
'Silver','BRA','HYPOLITO Diego');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Artistic Gymnastics','M','Men''s Horizontal Bar',
'Gold','GER','HAMBUECHEN Fabian');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Artistic Gymnastics','M','Men''s Horizontal Bar',
'Bronze','GBR','WILSON Nile');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Artistic Gymnastics','M','Men''s Horizontal Bar',
'Silver','USA','LEYVA Danell');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Athletics','M','Men''s 10,000m','Gold','GBR','FAR
AH Mohamed');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Athletics','M','Men''s 10,000m','Bronze','ETH','T
OLA Tamirat');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Athletics','M','Men''s 10,000m','Silver','KEN','T
ANUI Paul Kipngetich');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Athletics','M','Men''s 100m','Gold','JAM','BOLT U
sain');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Athletics','M','Men''s 100m','Silver','USA','GATL
IN Justin');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Athletics','M','Men''s 100m','Bronze','CAN','DE G
RASSE Andre');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Gold','CHN','Zha
ng');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Bronze','GBR','L
angridge');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Bronze','GBR','E
llis');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Silver','MAS','T
an');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Silver','MAS','G
oh');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Gold','CHN','Fu'
);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Beach Volleyball','M','Men','Gold','BRA','Cerutti
');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Beach Volleyball','M','Men','Gold','BRA','Oscar S
chmidt');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Beach Volleyball','M','Men','Silver','ITA','Nicol
ai');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Beach Volleyball','M','Men','Silver','ITA','Lupo'
);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Beach Volleyball','M','Men','Bronze','NED','Meeuw
sen');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Beach Volleyball','M','Men','Bronze','NED','Brouw
er');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Boxing','M','Men''s Bantam (56kg)','Gold','CUB','
RAMIREZ Robeisy');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Boxing','M','Men''s Bantam (56kg)','Bronze','UZB'
,'AKHMADALIEV Murodjon');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Boxing','M','Men''s Bantam (56kg)','Bronze','RUS'
,'NIKITIN Vladimir');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Boxing','M','Men''s Bantam (56kg)','Silver','USA'
,'STEVENSON Shakur');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Boxing','M','Men''s Fly (52kg)','Gold','UZB','ZOI
ROV Shakhobidin');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Boxing','M','Men''s Fly (52kg)','Bronze','CHN','H
U Jianguan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Slalom','M','Canoe Double (C2) Men','Gold',
'SVK','PETER Skantar');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Slalom','M','Canoe Double (C2) Men','Bronze
','FRA','GAUTHIER Klauss');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Slalom','M','Canoe Double (C2) Men','Bronze
','FRA','MATTHIEU Peche');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Slalom','M','Canoe Double (C2) Men','Silver
','GBR','RICHARD Hounslow');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Slalom','M','Canoe Double (C2) Men','Silver
','GBR','DAVID Florence');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Slalom','M','Canoe Double (C2) Men','Gold',
'SVK','LADISLAV Skantar');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Go
ld','GER','Brendel');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Br
onze','UKR','Mishchuk');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Br
onze','UKR','Ianchuk');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Si
lver','BRA','Queiroz dos Santos');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Si
lver','BRA','de Souza Silva');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Go
ld','GER','Vandrey');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Road','M','Men''s Individual Time Trial',
'Gold','SUI','CANCELLARA Fabian');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Road','M','Men''s Individual Time Trial',
'Bronze','GBR','FROOME Christopher');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Road','M','Men''s Individual Time Trial',
'Silver','NED','DUMOULIN Tom');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Road','M','Men''s Road Race','Gold','BEL'
,'VAN AVERMAET Greg');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Road','M','Men''s Road Race','Silver','DE
N','FUGLSANG Jakob');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Road','M','Men''s Road Race','Bronze','PO
L','MAJKA Rafal');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Track','M','Men''s Keirin','Gold','GBR','
KENNY Jason');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Track','M','Men''s Keirin','Bronze','MAS'
,'AWANG Azizulhasni');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Track','M','Men''s Keirin','Silver','NED'
,'BUCHLI Matthijs');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Track','M','Men''s Omnium','Gold','ITA','
VIVIANI Elia');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Track','M','Men''s Omnium','Bronze','DEN'
,'HANSEN Lasse Norman');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Cycling Track','M','Men''s Omnium','Silver','GBR'
,'CAVENDISH Mark');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Diving','M','Men''s 10m Platform','Gold','CHN','C
HEN Aisen');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Diving','M','Men''s 10m Platform','Bronze','USA',
'BOUDIA David');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Diving','M','Men''s 10m Platform','Silver','MEX',
'SANCHEZ German');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Diving','M','Men''s 3m Springboard','Gold','CHN',
'CAO Yuan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Diving','M','Men''s 3m Springboard','Silver','GBR
','LAUGHER Jack');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Diving','M','Men''s 3m Springboard','Bronze','GER
','HAUSDING Patrick');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Equestrian','X','Dressage Individual','Gold','GBR
','DUJARDIN Charlotte');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Equestrian','X','Dressage Individual','Bronze','G
ER','BRORING-SPREHE Kristina');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Equestrian','X','Dressage Individual','Silver','G
ER','WERTH Isabell');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Equestrian','X','Dressage Team','Gold','GER','Ger
many');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Equestrian','X','Dressage Team','Bronze','USA','U
nited States');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Equestrian','X','Dressage Team','Silver','GBR','G
reat Britain');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Fencing','M','Men''s Foil Individual','Gold','ITA
','GAROZZO Daniele');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Fencing','M','Men''s Foil Individual','Silver','U
SA','MASSIALAS Alexander');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Fencing','M','Men''s Foil Individual','Bronze','R
US','SAFIN Timur');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Fencing','M','Men''s Foil Team','Gold','RUS','Rus
sian Federation');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Fencing','M','Men''s Foil Team','Bronze','USA','U
nited States');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Fencing','M','Men''s Foil Team','Silver','FRA','F
rance');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Handball','M','Men','Gold','DEN','Denmark');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Handball','M','Men','Silver','FRA','France');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Handball','M','Men','Bronze','GER','Germany');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Handball','W','Women','Gold','RUS','Russian Feder
ation');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Handball','W','Women','Silver','FRA','France');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Handball','W','Women','Bronze','NOR','Norway');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Hockey','M','Men','Gold','ARG','Argentina');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Hockey','M','Men','Silver','BEL','Belgium');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Hockey','M','Men','Bronze','GER','Germany');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Hockey','W','Women','Gold','GBR','Great Britain')
;

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Hockey','W','Women','Silver','NED','Netherlands')
;

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Hockey','W','Women','Bronze','GER','Germany');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Judo','M','Men +100 kg','Gold','FRA','RINER Teddy
');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Judo','M','Men +100 kg','Bronze','BRA','SILVA Raf
ael');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Judo','M','Men +100 kg','Bronze','ISR','SASSON Or
');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Judo','M','Men +100 kg','Silver','JPN','HARASAWA 
Hisayoshi');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Judo','M','Men -100 kg','Gold','CZE','KRPALEK Luk
as');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Judo','M','Men -100 kg','Bronze','FRA','MARET Cyr
ille');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Modern Pentathlon','M','Men''s Individual','Gold'
,'RUS','LESUN Alexander');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Modern Pentathlon','M','Men''s Individual','Silve
r','UKR','TYMOSHCHENKO Pavlo');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Modern Pentathlon','M','Men''s Individual','Bronz
e','MEX','HERNANDEZ USCANGA Ismael Marcelo');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Modern Pentathlon','W','Women''s Individual','Gol
d','AUS','ESPOSITO Chloe');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Modern Pentathlon','W','Women''s Individual','Sil
ver','FRA','CLOUVEL Elodie');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Modern Pentathlon','W','Women''s Individual','Bro
nze','POL','NOWACKA Oktawia');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Group All-Around','Gold
','RUS','Russian Federation');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Group All-Around','Bron
ze','BUL','Bulgaria');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Group All-Around','Silv
er','ESP','Spain');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Individual All-Around',
'Gold','RUS','MAMUN Margarita');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Individual All-Around',
'Silver','RUS','KUDRYAVTSEVA Yana');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Individual All-Around',
'Bronze','UKR','RIZATDINOVA Ganna');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','G
old','FRA','Azou');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','B
ronze','NOR','Brun');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','B
ronze','NOR','Strandli');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','S
ilver','IRL','O''Donovan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','S
ilver','IRL','O''Donovan');
 *** Failure 2802 Duplicate row error in pivot_db.olympic_medal_winners.
                Statement# 1, Info =0 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','G
old','FRA','Houin');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Sailing','M','470 Men','Gold','CRO','Fantela');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Sailing','M','470 Men','Bronze','GRE','Kagialis')
;

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Sailing','M','470 Men','Bronze','GRE','Mantis');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Sailing','M','470 Men','Silver','AUS','Ryan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Sailing','M','470 Men','Silver','AUS','Belcher');


 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Sailing','M','470 Men','Gold','CRO','Marenic');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Swimming','M','Men''s 100m Backstroke','Gold','US
A','MURPHY Ryan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Swimming','M','Men''s 100m Backstroke','Bronze','
USA','PLUMMER David');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Swimming','M','Men''s 100m Backstroke','Silver','
CHN','XU Jiayu');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Swimming','M','Men''s 100m Breaststroke','Gold','
GBR','PEATY Adam');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Swimming','M','Men''s 100m Breaststroke','Bronze'
,'USA','MILLER Cody');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Swimming','M','Men''s 100m Breaststroke','Silver'
,'RSA','VAN DER BURGH Cameron');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Table Tennis','M','Men''s Singles','Gold','CHN','
MA Long');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Table Tennis','M','Men''s Singles','Bronze','JPN'
,'MIZUTANI Jun');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Table Tennis','M','Men''s Singles','Silver','CHN'
,'ZHANG Jike');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Table Tennis','M','Men''s Team','Gold','CHN','Chi
na');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Table Tennis','M','Men''s Team','Bronze','GER','G
ermany');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Table Tennis','M','Men''s Team','Silver','JPN','J
apan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Gold','AZE','ISAEV Ra
dik');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Bronze','KOR','CHA Do
ngmin');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Bronze','BRA','SIQUEI
RA Maicon');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Silver','NIG','ISSOUF
OU ALFAGA Abdoulrazak');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Taekwondo','M','Men -58kg','Gold','CHN','ZHAO Shu
ai');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Taekwondo','M','Men -58kg','Silver','THA','HANPRA
B Tawin');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Gold','ESP','Lopez'
);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Bronze','USA','John
son');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Bronze','USA','Sock
');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Silver','ROU','Teca
u');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Silver','ROU','Merg
ea');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Gold','ESP','Nadal'
);

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Trampoline Gymnastics','M','Men','Gold','BLR','HA
NCHAROU Uladzislau');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Trampoline Gymnastics','M','Men','Silver','CHN','
DONG Dong');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Trampoline Gymnastics','M','Men','Bronze','CHN','
GAO Lei');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Trampoline Gymnastics','W','Women','Gold','CAN','
MACLENNAN Rosannagh');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Trampoline Gymnastics','W','Women','Silver','GBR'
,'PAGE Bryony');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Trampoline Gymnastics','W','Women','Bronze','CHN'
,'LI Dan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Triathlon','M','Men','Gold','GBR','BROWNLEE Alist
air');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Triathlon','M','Men','Silver','GBR','BROWNLEE Jon
athan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Triathlon','M','Men','Bronze','RSA','SCHOEMAN Hen
ri');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Triathlon','W','Women','Gold','USA','JORGENSEN Gw
en');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Triathlon','W','Women','Silver','SUI','SPIRIG HUG
 Nicola');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Triathlon','W','Women','Bronze','GBR','HOLLAND Vi
cky');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Volleyball','M','Men','Gold','BRA','Brazil');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Volleyball','M','Men','Silver','ITA','Italy');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Volleyball','M','Men','Bronze','USA','United Stat
es');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Volleyball','W','Women','Gold','CHN','China');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Volleyball','W','Women','Silver','SRB','Serbia');


 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Volleyball','W','Women','Bronze','USA','United St
ates');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Water Polo','M','Men','Gold','SRB','Serbia');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Water Polo','M','Men','Silver','CRO','Croatia');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Water Polo','M','Men','Bronze','ITA','Italy');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Water Polo','W','Women','Gold','USA','United Stat
es');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Water Polo','W','Women','Silver','ITA','Italy');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Water Polo','W','Women','Bronze','RUS','Russian F
ederation');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Weightlifting','M','Men''s +105kg','Gold','GEO','
TALAKHADZE Lasha');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Weightlifting','M','Men''s +105kg','Bronze','GEO'
,'TURMANIDZE Irakli');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Weightlifting','M','Men''s +105kg','Silver','ARM'
,'MINASYAN Gor');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Weightlifting','M','Men''s 105kg','Gold','UZB','N
URUDINOV Ruslan');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Weightlifting','M','Men''s 105kg','Bronze','KAZ',
'ZAICHIKOV Alexandr');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Weightlifting','M','Men''s 105kg','Silver','ARM',
'MARTIROSYAN Simon');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 125 kg','Gold','
TUR','AKGUL Taha');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 125 kg','Bronze'
,'BLR','SAIDAU Ibrahim');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 125 kg','Bronze'
,'GEO','PETRIASHVILI Geno');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 125 kg','Silver'
,'IRI','GHASEMI Komeil Nemat');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 57 kg','Gold','G
EO','KHINCHEGASHVILI Vladimer');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----
Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NO
C,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 57 kg','Bronze',
'AZE','ALIYEV Haji');

 *** Insert completed. One row added. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

/***********************************************************************************
* CASE - 1                                                                         *
* This pivots results by medal. But the columns not listed in the pivot            *
* form an implicit group by. So this gives the medal total per athlete per event.  *
************************************************************************************/

select * from olympic_medal_winners   
pivot ( count(*) for medal in (   
 'Gold' gold, 'Silver' silver, 'Bronze' bronze   
))dt   
order by noc;

 *** Query completed. 179 rows found. 9 columns returned. 
 *** Total elapsed time was 1 second.

olympic_year        2016
       sport Hockey
      gender M
       event Men
         noc ARG
     athlete Argentina
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Weightlifting
      gender M
       event Men's 105kg
         noc ARM
     athlete MARTIROSYAN Simon
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Weightlifting
      gender M
       event Men's +105kg
         noc ARM
     athlete MINASYAN Gor
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Sailing
      gender M
       event 470 Men
         noc AUS
     athlete Ryan
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Modern Pentathlon
      gender W
       event Women's Individual
         noc AUS
     athlete ESPOSITO Chloe
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Sailing
      gender M
       event 470 Men
         noc AUS
     athlete Belcher
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Archery
      gender M
       event Men's Team
         noc AUS
     athlete Australia
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Taekwondo
      gender M
       event Men +80kg
         noc AZE
     athlete ISAEV Radik
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Wrestling
      gender M
       event Men's Freestyle 57 kg
         noc AZE
     athlete ALIYEV Haji
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Hockey
      gender M
       event Men
         noc BEL
     athlete Belgium
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Road
      gender M
       event Men's Road Race
         noc BEL
     athlete VAN AVERMAET Greg
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Wrestling
      gender M
       event Men's Freestyle 125 kg
         noc BLR
     athlete SAIDAU Ibrahim
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Trampoline Gymnastics
      gender M
       event Men
         noc BLR
     athlete HANCHAROU Uladzislau
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Volleyball
      gender M
       event Men
         noc BRA
     athlete Brazil
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Artistic Gymnastics
      gender M
       event Men's Floor Exercise
         noc BRA
     athlete HYPOLITO Diego
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Judo
      gender M
       event Men +100 kg
         noc BRA
     athlete SILVA Rafael
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Artistic Gymnastics
      gender M
       event Men's Floor Exercise
         noc BRA
     athlete MARIANO Arthur
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Beach Volleyball
      gender M
       event Men
         noc BRA
     athlete Cerutti
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Taekwondo
      gender M
       event Men +80kg
         noc BRA
     athlete SIQUEIRA Maicon
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Canoe Sprint
      gender M
       event Men's Canoe Double 1000m
         noc BRA
     athlete Queiroz dos Santos
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Beach Volleyball
      gender M
       event Men
         noc BRA
     athlete Oscar Schmidt
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Canoe Sprint
      gender M
       event Men's Canoe Double 1000m
         noc BRA
     athlete de Souza Silva
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Rhythmic Gymnastics
      gender W
       event Group All-Around
         noc BUL
     athlete Bulgaria
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Trampoline Gymnastics
      gender W
       event Women
         noc CAN
     athlete MACLENNAN Rosannagh
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Athletics
      gender M
       event Men's 100m
         noc CAN
     athlete DE GRASSE Andre
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Diving
      gender M
       event Men's 10m Platform
         noc CHN
     athlete CHEN Aisen
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Swimming
      gender M
       event Men's 100m Backstroke
         noc CHN
     athlete XU Jiayu
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Trampoline Gymnastics
      gender M
       event Men
         noc CHN
     athlete GAO Lei
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Table Tennis
      gender M
       event Men's Singles
         noc CHN
     athlete MA Long
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Trampoline Gymnastics
      gender W
       event Women
         noc CHN
     athlete LI Dan
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Badminton
      gender M
       event Men's Doubles
         noc CHN
     athlete Zhang
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Trampoline Gymnastics
      gender M
       event Men
         noc CHN
     athlete DONG Dong
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Boxing
      gender M
       event Men's Fly (52kg)
         noc CHN
     athlete HU Jianguan
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Taekwondo
      gender M
       event Men -58kg
         noc CHN
     athlete ZHAO Shuai
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Table Tennis
      gender M
       event Men's Team
         noc CHN
     athlete China
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Badminton
      gender M
       event Men's Doubles
         noc CHN
     athlete Fu
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Diving
      gender M
       event Men's 3m Springboard
         noc CHN
     athlete CAO Yuan
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Table Tennis
      gender M
       event Men's Singles
         noc CHN
     athlete ZHANG Jike
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Volleyball
      gender W
       event Women
         noc CHN
     athlete China
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Water Polo
      gender M
       event Men
         noc CRO
     athlete Croatia
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Sailing
      gender M
       event 470 Men
         noc CRO
     athlete Marenic
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Sailing
      gender M
       event 470 Men
         noc CRO
     athlete Fantela
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Boxing
      gender M
       event Men's Bantam (56kg)
         noc CUB
     athlete RAMIREZ Robeisy
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Judo
      gender M
       event Men -100 kg
         noc CZE
     athlete KRPALEK Lukas
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Handball
      gender M
       event Men
         noc DEN
     athlete Denmark
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Cycling Road
      gender M
       event Men's Road Race
         noc DEN
     athlete FUGLSANG Jakob
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Track
      gender M
       event Men's Omnium
         noc DEN
     athlete HANSEN Lasse Norman
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Tennis
      gender M
       event Men's Doubles
         noc ESP
     athlete Lopez
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Tennis
      gender M
       event Men's Doubles
         noc ESP
     athlete Nadal
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Rhythmic Gymnastics
      gender W
       event Group All-Around
         noc ESP
     athlete Spain
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Athletics
      gender M
       event Men's 10,000m
         noc ETH
     athlete TOLA Tamirat
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Handball
      gender W
       event Women
         noc FRA
     athlete France
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Archery
      gender M
       event Men's Individual
         noc FRA
     athlete VALLADONT Jean-Charles
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Judo
      gender M
       event Men +100 kg
         noc FRA
     athlete RINER Teddy
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Modern Pentathlon
      gender W
       event Women's Individual
         noc FRA
     athlete CLOUVEL Elodie
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Rowing
      gender M
       event Lightweight Men's Double Sculls
         noc FRA
     athlete Houin
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Rowing
      gender M
       event Lightweight Men's Double Sculls
         noc FRA
     athlete Azou
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Canoe Slalom
      gender M
       event Canoe Double (C2) Men
         noc FRA
     athlete GAUTHIER Klauss
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Canoe Slalom
      gender M
       event Canoe Double (C2) Men
         noc FRA
     athlete MATTHIEU Peche
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Fencing
      gender M
       event Men's Foil Team
         noc FRA
     athlete France
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Handball
      gender M
       event Men
         noc FRA
     athlete France
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Judo
      gender M
       event Men -100 kg
         noc FRA
     athlete MARET Cyrille
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Equestrian
      gender X
       event Dressage Individual
         noc GBR
     athlete DUJARDIN Charlotte
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Cycling Track
      gender M
       event Men's Keirin
         noc GBR
     athlete KENNY Jason
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Cycling Road
      gender M
       event Men's Individual Time Trial
         noc GBR
     athlete FROOME Christopher
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Athletics
      gender M
       event Men's 10,000m
         noc GBR
     athlete FARAH Mohamed
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Triathlon
      gender M
       event Men
         noc GBR
     athlete BROWNLEE Alistair
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Artistic Gymnastics
      gender M
       event Men's Horizontal Bar
         noc GBR
     athlete WILSON Nile
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Canoe Slalom
      gender M
       event Canoe Double (C2) Men
         noc GBR
     athlete DAVID Florence
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Trampoline Gymnastics
      gender W
       event Women
         noc GBR
     athlete PAGE Bryony
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Canoe Slalom
      gender M
       event Canoe Double (C2) Men
         noc GBR
     athlete RICHARD Hounslow
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Track
      gender M
       event Men's Omnium
         noc GBR
     athlete CAVENDISH Mark
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Badminton
      gender M
       event Men's Doubles
         noc GBR
     athlete Langridge
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Triathlon
      gender W
       event Women
         noc GBR
     athlete HOLLAND Vicky
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Hockey
      gender W
       event Women
         noc GBR
     athlete Great Britain
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Triathlon
      gender M
       event Men
         noc GBR
     athlete BROWNLEE Jonathan
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Artistic Gymnastics
      gender M
       event Men's Floor Exercise
         noc GBR
     athlete WHITLOCK Max
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Diving
      gender M
       event Men's 3m Springboard
         noc GBR
     athlete LAUGHER Jack
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Swimming
      gender M
       event Men's 100m Breaststroke
         noc GBR
     athlete PEATY Adam
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Badminton
      gender M
       event Men's Doubles
         noc GBR
     athlete Ellis
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Equestrian
      gender X
       event Dressage Team
         noc GBR
     athlete Great Britain
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Weightlifting
      gender M
       event Men's +105kg
         noc GEO
     athlete TURMANIDZE Irakli
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Wrestling
      gender M
       event Men's Freestyle 125 kg
         noc GEO
     athlete PETRIASHVILI Geno
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Wrestling
      gender M
       event Men's Freestyle 57 kg
         noc GEO
     athlete KHINCHEGASHVILI Vladimer
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Weightlifting
      gender M
       event Men's +105kg
         noc GEO
     athlete TALAKHADZE Lasha
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Table Tennis
      gender M
       event Men's Team
         noc GER
     athlete Germany
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Canoe Sprint
      gender M
       event Men's Canoe Double 1000m
         noc GER
     athlete Brendel
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Equestrian
      gender X
       event Dressage Team
         noc GER
     athlete Germany
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Equestrian
      gender X
       event Dressage Individual
         noc GER
     athlete WERTH Isabell
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Canoe Sprint
      gender M
       event Men's Canoe Double 1000m
         noc GER
     athlete Vandrey
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Diving
      gender M
       event Men's 3m Springboard
         noc GER
     athlete HAUSDING Patrick
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Artistic Gymnastics
      gender M
       event Men's Horizontal Bar
         noc GER
     athlete HAMBUECHEN Fabian
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Hockey
      gender M
       event Men
         noc GER
     athlete Germany
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Hockey
      gender W
       event Women
         noc GER
     athlete Germany
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Handball
      gender M
       event Men
         noc GER
     athlete Germany
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Equestrian
      gender X
       event Dressage Individual
         noc GER
     athlete BRORING-SPREHE Kristina
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Sailing
      gender M
       event 470 Men
         noc GRE
     athlete Kagialis
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Sailing
      gender M
       event 470 Men
         noc GRE
     athlete Mantis
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Wrestling
      gender M
       event Men's Freestyle 125 kg
         noc IRI
     athlete GHASEMI Komeil Nemat
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Rowing
      gender M
       event Lightweight Men's Double Sculls
         noc IRL
     athlete O'Donovan
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Judo
      gender M
       event Men +100 kg
         noc ISR
     athlete SASSON Or
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Beach Volleyball
      gender M
       event Men
         noc ITA
     athlete Nicolai
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Volleyball
      gender M
       event Men
         noc ITA
     athlete Italy
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Water Polo
      gender W
       event Women
         noc ITA
     athlete Italy
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Beach Volleyball
      gender M
       event Men
         noc ITA
     athlete Lupo
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Track
      gender M
       event Men's Omnium
         noc ITA
     athlete VIVIANI Elia
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Fencing
      gender M
       event Men's Foil Individual
         noc ITA
     athlete GAROZZO Daniele
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Water Polo
      gender M
       event Men
         noc ITA
     athlete Italy
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Athletics
      gender M
       event Men's 100m
         noc JAM
     athlete BOLT Usain
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Table Tennis
      gender M
       event Men's Team
         noc JPN
     athlete Japan
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Judo
      gender M
       event Men +100 kg
         noc JPN
     athlete HARASAWA Hisayoshi
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Table Tennis
      gender M
       event Men's Singles
         noc JPN
     athlete MIZUTANI Jun
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Weightlifting
      gender M
       event Men's 105kg
         noc KAZ
     athlete ZAICHIKOV Alexandr
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Athletics
      gender M
       event Men's 10,000m
         noc KEN
     athlete TANUI Paul Kipngetich
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Archery
      gender M
       event Men's Individual
         noc KOR
     athlete KU Bonchan
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Archery
      gender M
       event Men's Team
         noc KOR
     athlete Republic of Korea
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Taekwondo
      gender M
       event Men +80kg
         noc KOR
     athlete CHA Dongmin
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Badminton
      gender M
       event Men's Doubles
         noc MAS
     athlete Tan
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Badminton
      gender M
       event Men's Doubles
         noc MAS
     athlete Goh
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Track
      gender M
       event Men's Keirin
         noc MAS
     athlete AWANG Azizulhasni
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Diving
      gender M
       event Men's 10m Platform
         noc MEX
     athlete SANCHEZ German
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Modern Pentathlon
      gender M
       event Men's Individual
         noc MEX
     athlete HERNANDEZ USCANGA Ismael Marcelo
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Cycling Road
      gender M
       event Men's Individual Time Trial
         noc NED
     athlete DUMOULIN Tom
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Hockey
      gender W
       event Women
         noc NED
     athlete Netherlands
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Track
      gender M
       event Men's Keirin
         noc NED
     athlete BUCHLI Matthijs
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Beach Volleyball
      gender M
       event Men
         noc NED
     athlete Brouwer
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Beach Volleyball
      gender M
       event Men
         noc NED
     athlete Meeuwsen
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Taekwondo
      gender M
       event Men +80kg
         noc NIG
     athlete ISSOUFOU ALFAGA Abdoulrazak
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Rowing
      gender M
       event Lightweight Men's Double Sculls
         noc NOR
     athlete Brun
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Rowing
      gender M
       event Lightweight Men's Double Sculls
         noc NOR
     athlete Strandli
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Handball
      gender W
       event Women
         noc NOR
     athlete Norway
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Cycling Road
      gender M
       event Men's Road Race
         noc POL
     athlete MAJKA Rafal
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Modern Pentathlon
      gender W
       event Women's Individual
         noc POL
     athlete NOWACKA Oktawia
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Tennis
      gender M
       event Men's Doubles
         noc ROU
     athlete Tecau
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Tennis
      gender M
       event Men's Doubles
         noc ROU
     athlete Mergea
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Swimming
      gender M
       event Men's 100m Breaststroke
         noc RSA
     athlete VAN DER BURGH Cameron
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Triathlon
      gender M
       event Men
         noc RSA
     athlete SCHOEMAN Henri
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Rhythmic Gymnastics
      gender W
       event Individual All-Around
         noc RUS
     athlete KUDRYAVTSEVA Yana
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Modern Pentathlon
      gender M
       event Men's Individual
         noc RUS
     athlete LESUN Alexander
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Handball
      gender W
       event Women
         noc RUS
     athlete Russian Federation
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Boxing
      gender M
       event Men's Bantam (56kg)
         noc RUS
     athlete NIKITIN Vladimir
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Rhythmic Gymnastics
      gender W
       event Group All-Around
         noc RUS
     athlete Russian Federation
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Rhythmic Gymnastics
      gender W
       event Individual All-Around
         noc RUS
     athlete MAMUN Margarita
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Water Polo
      gender W
       event Women
         noc RUS
     athlete Russian Federation
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Fencing
      gender M
       event Men's Foil Team
         noc RUS
     athlete Russian Federation
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Fencing
      gender M
       event Men's Foil Individual
         noc RUS
     athlete SAFIN Timur
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Volleyball
      gender W
       event Women
         noc SRB
     athlete Serbia
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Water Polo
      gender M
       event Men
         noc SRB
     athlete Serbia
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Triathlon
      gender W
       event Women
         noc SUI
     athlete SPIRIG HUG Nicola
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Cycling Road
      gender M
       event Men's Individual Time Trial
         noc SUI
     athlete CANCELLARA Fabian
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Canoe Slalom
      gender M
       event Canoe Double (C2) Men
         noc SVK
     athlete PETER Skantar
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Canoe Slalom
      gender M
       event Canoe Double (C2) Men
         noc SVK
     athlete LADISLAV Skantar
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Taekwondo
      gender M
       event Men -58kg
         noc THA
     athlete HANPRAB Tawin
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Wrestling
      gender M
       event Men's Freestyle 125 kg
         noc TUR
     athlete AKGUL Taha
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Rhythmic Gymnastics
      gender W
       event Individual All-Around
         noc UKR
     athlete RIZATDINOVA Ganna
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Canoe Sprint
      gender M
       event Men's Canoe Double 1000m
         noc UKR
     athlete Ianchuk
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Modern Pentathlon
      gender M
       event Men's Individual
         noc UKR
     athlete TYMOSHCHENKO Pavlo
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Canoe Sprint
      gender M
       event Men's Canoe Double 1000m
         noc UKR
     athlete Mishchuk
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Diving
      gender M
       event Men's 10m Platform
         noc USA
     athlete BOUDIA David
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Tennis
      gender M
       event Men's Doubles
         noc USA
     athlete Johnson
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Archery
      gender M
       event Men's Team
         noc USA
     athlete United States
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Volleyball
      gender M
       event Men
         noc USA
     athlete United States
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Swimming
      gender M
       event Men's 100m Breaststroke
         noc USA
     athlete MILLER Cody
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Fencing
      gender M
       event Men's Foil Team
         noc USA
     athlete United States
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Tennis
      gender M
       event Men's Doubles
         noc USA
     athlete Sock
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Equestrian
      gender X
       event Dressage Team
         noc USA
     athlete United States
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Fencing
      gender M
       event Men's Foil Individual
         noc USA
     athlete MASSIALAS Alexander
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Boxing
      gender M
       event Men's Bantam (56kg)
         noc USA
     athlete STEVENSON Shakur
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Artistic Gymnastics
      gender M
       event Men's Horizontal Bar
         noc USA
     athlete LEYVA Danell
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Volleyball
      gender W
       event Women
         noc USA
     athlete United States
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Water Polo
      gender W
       event Women
         noc USA
     athlete United States
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Archery
      gender M
       event Men's Individual
         noc USA
     athlete ELLISON Brady
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Swimming
      gender M
       event Men's 100m Backstroke
         noc USA
     athlete MURPHY Ryan
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Triathlon
      gender W
       event Women
         noc USA
     athlete JORGENSEN Gwen
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Athletics
      gender M
       event Men's 100m
         noc USA
     athlete GATLIN Justin
        gold           0
      silver           1
      bronze           0
olympic_year        2016
       sport Swimming
      gender M
       event Men's 100m Backstroke
         noc USA
     athlete PLUMMER David
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Weightlifting
      gender M
       event Men's 105kg
         noc UZB
     athlete NURUDINOV Ruslan
        gold           1
      silver           0
      bronze           0
olympic_year        2016
       sport Boxing
      gender M
       event Men's Bantam (56kg)
         noc UZB
     athlete AKHMADALIEV Murodjon
        gold           0
      silver           0
      bronze           1
olympic_year        2016
       sport Boxing
      gender M
       event Men's Fly (52kg)
         noc UZB
     athlete ZOIROV Shakhobidin
        gold           1
      silver           0
      bronze           0

+---------+---------+---------+---------+---------+---------+---------+----

/**************************************************************************************************
* CASE - 2                                                                                        *
* To overcome the problem in the previous statement, this selects just the columns                *
* you need in the sub-query. But some events have multiple people who win the same                *
* medal - for example, doubles tennis. This pivot counts rows in the table, not individual events.*
***************************************************************************************************/

sel * from (select noc, medal from olympic_medal_winners)dt  
pivot ( count(*) for medal in ('Gold', 'Silver' , 'Bronze' )) dt1    
order  by 2 desc, 3 desc, 4 desc;

 *** Query completed. 47 rows found. 4 columns returned. 
 *** Total elapsed time was 1 second.

     noc  CHN
  'Gold'            8
'Silver'            3
'Bronze'            3
     noc  GBR
  'Gold'            7
'Silver'            7
'Bronze'            5
     noc  RUS
  'Gold'            5
'Silver'            1
'Bronze'            3
     noc  GER
  'Gold'            4
'Silver'            1
'Bronze'            6
     noc  USA
  'Gold'            3
'Silver'            5
'Bronze'           10
     noc  FRA
  'Gold'            3
'Silver'            5
'Bronze'            3
     noc  BRA
  'Gold'            3
'Silver'            3
'Bronze'            3
     noc  ITA
  'Gold'            2
'Silver'            4
'Bronze'            1
     noc  CRO
  'Gold'            2
'Silver'            1
'Bronze'            0
     noc  ESP
  'Gold'            2
'Silver'            1
'Bronze'            0
     noc  GEO
  'Gold'            2
'Silver'            0
'Bronze'            2
     noc  KOR
  'Gold'            2
'Silver'            0
'Bronze'            1
     noc  UZB
  'Gold'            2
'Silver'            0
'Bronze'            1
     noc  SVK
  'Gold'            2
'Silver'            0
'Bronze'            0
     noc  AUS
  'Gold'            1
'Silver'            2
'Bronze'            1
     noc  DEN
  'Gold'            1
'Silver'            1
'Bronze'            1
     noc  SRB
  'Gold'            1
'Silver'            1
'Bronze'            0
     noc  SUI
  'Gold'            1
'Silver'            1
'Bronze'            0
     noc  BEL
  'Gold'            1
'Silver'            1
'Bronze'            0
     noc  AZE
  'Gold'            1
'Silver'            0
'Bronze'            1
     noc  BLR
  'Gold'            1
'Silver'            0
'Bronze'            1
     noc  CAN
  'Gold'            1
'Silver'            0
'Bronze'            1
     noc  CUB
  'Gold'            1
'Silver'            0
'Bronze'            0
     noc  TUR
  'Gold'            1
'Silver'            0
'Bronze'            0
     noc  JAM
  'Gold'            1
'Silver'            0
'Bronze'            0
     noc  CZE
  'Gold'            1
'Silver'            0
'Bronze'            0
     noc  ARG
  'Gold'            1
'Silver'            0
'Bronze'            0
     noc  NED
  'Gold'            0
'Silver'            3
'Bronze'            2
     noc  MAS
  'Gold'            0
'Silver'            2
'Bronze'            1
     noc  JPN
  'Gold'            0
'Silver'            2
'Bronze'            1
     noc  ROU
  'Gold'            0
'Silver'            2
'Bronze'            0
     noc  ARM
  'Gold'            0
'Silver'            2
'Bronze'            0
     noc  UKR
  'Gold'            0
'Silver'            1
'Bronze'            3
     noc  MEX
  'Gold'            0
'Silver'            1
'Bronze'            1
     noc  RSA
  'Gold'            0
'Silver'            1
'Bronze'            1
     noc  NIG
  'Gold'            0
'Silver'            1
'Bronze'            0
     noc  IRI
  'Gold'            0
'Silver'            1
'Bronze'            0
     noc  KEN
  'Gold'            0
'Silver'            1
'Bronze'            0
     noc  THA
  'Gold'            0
'Silver'            1
'Bronze'            0
     noc  IRL
  'Gold'            0
'Silver'            1
'Bronze'            0
     noc  NOR
  'Gold'            0
'Silver'            0
'Bronze'            3
     noc  POL
  'Gold'            0
'Silver'            0
'Bronze'            2
     noc  GRE
  'Gold'            0
'Silver'            0
'Bronze'            2
     noc  ISR
  'Gold'            0
'Silver'            0
'Bronze'            1
     noc  KAZ
  'Gold'            0
'Silver'            0
'Bronze'            1
     noc  BUL
  'Gold'            0
'Silver'            0
'Bronze'            1
     noc  ETH
  'Gold'            0
'Silver'            0
'Bronze'            1

+---------+---------+---------+---------+---------+---------+---------+----

/*************************************************************************************
* CASE - 3                                                                           *
* This solves the over counting problem in the previous statement. It does this by   *
* finding the distinct values for sport, event and gender then counting the results. *
**************************************************************************************/

select * from (   
 select noc, medal, sport, event, gender   
 from olympic_medal_winners   
)dt
pivot ( count(distinct sport ||'#'|| event ||'#'||gender ) for medal in ( 
  
 'Gold' gold, 'Silver' silver, 'Bronze' bronze   
))dt1   
order  by 2 desc, 3 desc, 4 desc ;

 *** Query completed. 47 rows found. 4 columns returned. 
 *** Total elapsed time was 1 second.

   noc  GBR
  gold            7
silver            6
bronze            4
   noc  CHN
  gold            7
silver            3
bronze            3
   noc  RUS
  gold            5
silver            1
bronze            3
   noc  USA
  gold            3
silver            5
bronze            9
   noc  GER
  gold            3
silver            1
bronze            6
   noc  FRA
  gold            2
silver            5
bronze            2
   noc  ITA
  gold            2
silver            3
bronze            1
   noc  BRA
  gold            2
silver            2
bronze            3
   noc  GEO
  gold            2
silver            0
bronze            2
   noc  KOR
  gold            2
silver            0
bronze            1
   noc  UZB
  gold            2
silver            0
bronze            1
   noc  DEN
  gold            1
silver            1
bronze            1
   noc  AUS
  gold            1
silver            1
bronze            1
   noc  SUI
  gold            1
silver            1
bronze            0
   noc  SRB
  gold            1
silver            1
bronze            0
   noc  CRO
  gold            1
silver            1
bronze            0
   noc  BEL
  gold            1
silver            1
bronze            0
   noc  ESP
  gold            1
silver            1
bronze            0
   noc  AZE
  gold            1
silver            0
bronze            1
   noc  BLR
  gold            1
silver            0
bronze            1
   noc  CAN
  gold            1
silver            0
bronze            1
   noc  CUB
  gold            1
silver            0
bronze            0
   noc  JAM
  gold            1
silver            0
bronze            0
   noc  SVK
  gold            1
silver            0
bronze            0
   noc  TUR
  gold            1
silver            0
bronze            0
   noc  CZE
  gold            1
silver            0
bronze            0
   noc  ARG
  gold            1
silver            0
bronze            0
   noc  NED
  gold            0
silver            3
bronze            1
   noc  JPN
  gold            0
silver            2
bronze            1
   noc  ARM
  gold            0
silver            2
bronze            0
   noc  UKR
  gold            0
silver            1
bronze            2
   noc  MEX
  gold            0
silver            1
bronze            1
   noc  RSA
  gold            0
silver            1
bronze            1
   noc  MAS
  gold            0
silver            1
bronze            1
   noc  IRI
  gold            0
silver            1
bronze            0
   noc  NIG
  gold            0
silver            1
bronze            0
   noc  ROU
  gold            0
silver            1
bronze            0
   noc  KEN
  gold            0
silver            1
bronze            0
   noc  THA
  gold            0
silver            1
bronze            0
   noc  IRL
  gold            0
silver            1
bronze            0
   noc  POL
  gold            0
silver            0
bronze            2
   noc  NOR
  gold            0
silver            0
bronze            2
   noc  ISR
  gold            0
silver            0
bronze            1
   noc  KAZ
  gold            0
silver            0
bronze            1
   noc  BUL
  gold            0
silver            0
bronze            1
   noc  GRE
  gold            0
silver            0
bronze            1
   noc  ETH
  gold            0
silver            0
bronze            1

+---------+---------+---------+---------+---------+---------+---------+----


/*************************************************************************************
* CASE - 4                                                                           *
* This produces a matrix, sports across the top countries down the side.             *
* There's an X for each sport for which that country has a row in the table.         *
**************************************************************************************/

select * from (     
  select noc, sport     
  from   olympic_medal_winners     
)dt     
pivot (min('X') for sport in (     
  'Archery' as arc, 'Athletics' as ath, 'Hockey' as hoc,   
  'Judo' as jud, 'Sailing' as sai, 'Wrestling' as wre  
  )      
)dt1   
order  by noc;

 *** Query completed. 47 rows found. 7 columns returned. 
 *** Total elapsed time was 1 second.

noc  ARG
arc  ?
ath  ?
hoc  X
jud  ?
sai  ?
wre  ?
noc  ARM
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  AUS
arc  X
ath  ?
hoc  ?
jud  ?
sai  X
wre  ?
noc  AZE
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  X
noc  BEL
arc  ?
ath  ?
hoc  X
jud  ?
sai  ?
wre  ?
noc  BLR
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  X
noc  BRA
arc  ?
ath  ?
hoc  ?
jud  X
sai  ?
wre  ?
noc  BUL
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  CAN
arc  ?
ath  X
hoc  ?
jud  ?
sai  ?
wre  ?
noc  CHN
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  CRO
arc  ?
ath  ?
hoc  ?
jud  ?
sai  X
wre  ?
noc  CUB
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  CZE
arc  ?
ath  ?
hoc  ?
jud  X
sai  ?
wre  ?
noc  DEN
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  ESP
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  ETH
arc  ?
ath  X
hoc  ?
jud  ?
sai  ?
wre  ?
noc  FRA
arc  X
ath  ?
hoc  ?
jud  X
sai  ?
wre  ?
noc  GBR
arc  ?
ath  X
hoc  X
jud  ?
sai  ?
wre  ?
noc  GEO
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  X
noc  GER
arc  ?
ath  ?
hoc  X
jud  ?
sai  ?
wre  ?
noc  GRE
arc  ?
ath  ?
hoc  ?
jud  ?
sai  X
wre  ?
noc  IRI
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  X
noc  IRL
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  ISR
arc  ?
ath  ?
hoc  ?
jud  X
sai  ?
wre  ?
noc  ITA
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  JAM
arc  ?
ath  X
hoc  ?
jud  ?
sai  ?
wre  ?
noc  JPN
arc  ?
ath  ?
hoc  ?
jud  X
sai  ?
wre  ?
noc  KAZ
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  KEN
arc  ?
ath  X
hoc  ?
jud  ?
sai  ?
wre  ?
noc  KOR
arc  X
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  MAS
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  MEX
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  NED
arc  ?
ath  ?
hoc  X
jud  ?
sai  ?
wre  ?
noc  NIG
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  NOR
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  POL
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  ROU
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  RSA
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  RUS
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  SRB
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  SUI
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  SVK
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  THA
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  TUR
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  X
noc  UKR
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?
noc  USA
arc  X
ath  X
hoc  ?
jud  ?
sai  ?
wre  ?
noc  UZB
arc  ?
ath  ?
hoc  ?
jud  ?
sai  ?
wre  ?

+---------+---------+---------+---------+---------+---------+---------+----

/*This creates the final medal table for the unpivot example below.*/

/*************************************************************************************
* CASE - 5                                                                           *
* This creates the final medal table for the unpivot example below.                  * 
**************************************************************************************/

create table olympic_medal_tables1 as  (
select * from (  
 select noc, medal, sport, event, gender  
 from olympic_medal_winners  
)dt  
pivot ( count(distinct sport ||'#'|| event ||'#'||gender ) medals,   
  count(distinct sport) sports  
  for medal in (  
 'Gold' gold, 'Silver' silver, 'Bronze' bronze  
))dt1  )
WITH DATA;

 *** Table has been created. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

/*************************************************************************************
* CASE - 6                                                                           *
* Unpivot takes the columns and converts them back to rows.                          * 
**************************************************************************************/

select * from 
(select * from olympic_medal_tables1)dt    
unpivot ((medal_count, sport_count) for medal_colour in (   
  (gold_medals, gold_sports) as 'GOLD',    
  (silver_medals, silver_sports) as 'SILVER',    
  (bronze_medals, bronze_sports) as 'BRONZE'   
))dt1 order by 1;

 *** Query completed. 141 rows found. 4 columns returned. 
 *** Total elapsed time was 1 second.

         noc ARG
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc ARG
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc ARG
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc ARM
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc ARM
medal_colour SILVER
 medal_count           2
 sport_count           1
         noc ARM
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc AUS
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc AUS
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc AUS
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc AZE
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc AZE
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc AZE
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc BEL
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc BEL
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc BEL
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc BLR
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc BLR
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc BLR
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc BRA
medal_colour BRONZE
 medal_count           3
 sport_count           3
         noc BRA
medal_colour GOLD
 medal_count           2
 sport_count           2
         noc BRA
medal_colour SILVER
 medal_count           2
 sport_count           2
         noc BUL
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc BUL
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc BUL
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc CAN
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc CAN
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc CAN
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc CHN
medal_colour GOLD
 medal_count           7
 sport_count           5
         noc CHN
medal_colour BRONZE
 medal_count           3
 sport_count           2
         noc CHN
medal_colour SILVER
 medal_count           3
 sport_count           3
         noc CRO
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc CRO
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc CRO
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc CUB
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc CUB
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc CUB
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc CZE
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc CZE
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc CZE
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc DEN
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc DEN
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc DEN
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc ESP
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc ESP
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc ESP
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc ETH
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc ETH
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc ETH
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc FRA
medal_colour BRONZE
 medal_count           2
 sport_count           2
         noc FRA
medal_colour SILVER
 medal_count           5
 sport_count           4
         noc FRA
medal_colour GOLD
 medal_count           2
 sport_count           2
         noc GBR
medal_colour SILVER
 medal_count           6
 sport_count           6
         noc GBR
medal_colour GOLD
 medal_count           7
 sport_count           7
         noc GBR
medal_colour BRONZE
 medal_count           4
 sport_count           4
         noc GEO
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc GEO
medal_colour BRONZE
 medal_count           2
 sport_count           2
         noc GEO
medal_colour GOLD
 medal_count           2
 sport_count           2
         noc GER
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc GER
medal_colour GOLD
 medal_count           3
 sport_count           3
         noc GER
medal_colour BRONZE
 medal_count           6
 sport_count           5
         noc GRE
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc GRE
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc GRE
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc IRI
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc IRI
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc IRI
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc IRL
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc IRL
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc IRL
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc ISR
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc ISR
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc ISR
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc ITA
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc ITA
medal_colour SILVER
 medal_count           3
 sport_count           3
         noc ITA
medal_colour GOLD
 medal_count           2
 sport_count           2
         noc JAM
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc JAM
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc JAM
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc JPN
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc JPN
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc JPN
medal_colour SILVER
 medal_count           2
 sport_count           2
         noc KAZ
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc KAZ
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc KAZ
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc KEN
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc KEN
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc KEN
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc KOR
medal_colour GOLD
 medal_count           2
 sport_count           1
         noc KOR
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc KOR
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc MAS
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc MAS
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc MAS
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc MEX
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc MEX
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc MEX
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc NED
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc NED
medal_colour SILVER
 medal_count           3
 sport_count           3
         noc NED
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc NIG
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc NIG
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc NIG
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc NOR
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc NOR
medal_colour BRONZE
 medal_count           2
 sport_count           2
         noc NOR
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc POL
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc POL
medal_colour BRONZE
 medal_count           2
 sport_count           2
         noc POL
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc ROU
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc ROU
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc ROU
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc RSA
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc RSA
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc RSA
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc RUS
medal_colour BRONZE
 medal_count           3
 sport_count           3
         noc RUS
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc RUS
medal_colour GOLD
 medal_count           5
 sport_count           4
         noc SRB
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc SRB
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc SRB
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc SUI
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc SUI
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc SUI
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc SVK
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc SVK
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc SVK
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc THA
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc THA
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc THA
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc TUR
medal_colour BRONZE
 medal_count           0
 sport_count           0
         noc TUR
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc TUR
medal_colour GOLD
 medal_count           1
 sport_count           1
         noc UKR
medal_colour BRONZE
 medal_count           2
 sport_count           2
         noc UKR
medal_colour SILVER
 medal_count           1
 sport_count           1
         noc UKR
medal_colour GOLD
 medal_count           0
 sport_count           0
         noc USA
medal_colour BRONZE
 medal_count           9
 sport_count           7
         noc USA
medal_colour SILVER
 medal_count           5
 sport_count           5
         noc USA
medal_colour GOLD
 medal_count           3
 sport_count           3
         noc UZB
medal_colour BRONZE
 medal_count           1
 sport_count           1
         noc UZB
medal_colour SILVER
 medal_count           0
 sport_count           0
         noc UZB
medal_colour GOLD
 medal_count           2
 sport_count           2

+---------+---------+---------+---------+---------+---------+---------+----

/*************************************************************************************************
* CASE - 7                                                                                       *
* This creates the table of medals won by each country per sport for use in the examples below.  * 
**************************************************************************************************/

create table olympic_country_sport_medals as   
(select * from (   
  select noc, sport   
  from   olympic_medal_winners   
)dt   
pivot (count(sport) for sport in (   
  'Athletics' as ath, 'Artistic Gymnastics' as gym, 'Cycling Track' as cyc
,  
  'Boxing' as box, 'Sailing' as sai  
  )    
)dt1)   
WITH DATA;

 *** Table has been created. 
 *** Total elapsed time was 1 second.


+---------+---------+---------+---------+---------+---------+---------+----

/*************************************************************************************************
* CASE - 8                                                                                       *
* This switches the rows and columns over (a transpose). It does so by chaining a pivot          *
* followed by an unpivot.                                                                        *  
**************************************************************************************************/

select * from ( select * from ( select * from olympic_country_sport_medals)
dt
pivot(
sum(ath) as ath, sum(box) as box, sum(gym) as gym, sum(sai) as sai, sum(cy
c) as cyc   
for noc in ('BRA' BRA, 'CHN' CHN, 'DEN' DEN, 'ESP' ESP, 'ETH' ETH, 'GRE' G
RE )) dt1) dt2
unpivot(
(BRA, CHN, DEN, ESP, ETH, GRE ) for sport in (   
(BRA_ATH, CHN_ATH, DEN_ATH,  ESP_ATH,  ETH_ATH, GRE_ATH) as 'Athletics',  
 
(BRA_GYM, CHN_GYM, DEN_GYM,  ESP_GYM,  ETH_GYM, GRE_GYM) as 'Artistic Gym'
,   
(BRA_BOX, CHN_BOX, DEN_BOX,  ESP_BOX,  ETH_BOX, GRE_BOX) as 'Boxing',   
(BRA_SAI, CHN_SAI, DEN_SAI,  ESP_SAI,  ETH_SAI, GRE_SAI) as 'Sailing',   
(BRA_CYC, CHN_CYC, DEN_CYC,  ESP_CYC,  ETH_CYC, GRE_CYC) as 'Track Cycling
'   
)) dt3;

 *** Query completed. 5 rows found. 7 columns returned. 
 *** Total elapsed time was 1 second.

sport Athletics
  BRA           0
  CHN           0
  DEN           0
  ESP           0
  ETH           1
  GRE           0
sport Artistic Gym
  BRA           2
  CHN           0
  DEN           0
  ESP           0
  ETH           0
  GRE           0
sport Boxing
  BRA           0
  CHN           1
  DEN           0
  ESP           0
  ETH           0
  GRE           0
sport Sailing
  BRA           0
  CHN           0
  DEN           0
  ESP           0
  ETH           0
  GRE           2
sport Track Cycling
  BRA           0
  CHN           0
  DEN           1
  ESP           0
  ETH           0
  GRE           0

+---------+---------+---------+---------+---------+---------+---------+----

/*************************************************************************************************
* CASE - 9                                                                                       *
* This is the simplified version of above query.                                                 *
* This switches the rows and columns over (a transpose). It does so by chaining a unpivot        *
* followed by an pivot.                                                                          *  
**************************************************************************************************/

select * from ( select * from olympic_country_sport_medals
unpivot(medalval
for sport in (ath as 'Athletics', box as 'Boxing', gym as 'Artistic Gym', 
sai as 'Sailing', cyc as 'Track Cycling'))dt1)dt2
pivot(sum(medalval)
for noc in ('BRA', 'CHN', 'DEN', 'ESP', 'ETH', 'GRE'))dt3;

 *** Query completed. 5 rows found. 7 columns returned. 
 *** Total elapsed time was 1 second.

sport Athletics
'BRA'           0
'CHN'           0
'DEN'           0
'ESP'           0
'ETH'           1
'GRE'           0
sport Track Cycling
'BRA'           0
'CHN'           0
'DEN'           1
'ESP'           0
'ETH'           0
'GRE'           0
sport Sailing
'BRA'           0
'CHN'           0
'DEN'           0
'ESP'           0
'ETH'           0
'GRE'           2
sport Artistic Gym
'BRA'           2
'CHN'           0
'DEN'           0
'ESP'           0
'ETH'           0
'GRE'           0
sport Boxing
'BRA'           0
'CHN'           1
'DEN'           0
'ESP'           0
'ETH'           0
'GRE'           0

+---------+---------+---------+---------+---------+---------+---------+----

.logoff;
 *** You are now logged off from the DBC.
 *** BTEQ exiting due to EOF on stdin.
 *** Exiting BTEQ...
 *** RC (return code) = 8 
