Oracle Live SQL - Script: Pivot and unpivot examples using Olympic data

Pivot and unpivot examples using Olympic data

Additional Information

Statement 1

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

Table created.

Statement 2

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

1 row(s) inserted.

Statement 3

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

1 row(s) inserted.

Statement 4

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

1 row(s) inserted.

Statement 5

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

1 row(s) inserted.

Statement 6

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Archery','M','Men''s Team','Bronze','AUS','Australia')

1 row(s) inserted.

Statement 7

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

1 row(s) inserted.

Statement 8

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

1 row(s) inserted.

Statement 9

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

1 row(s) inserted.

Statement 10

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

1 row(s) inserted.

Statement 11

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

1 row(s) inserted.

Statement 12

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

1 row(s) inserted.

Statement 13

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

1 row(s) inserted.

Statement 14

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Athletics','M','Men''s 10,000m','Gold','GBR','FARAH Mohamed')

1 row(s) inserted.

Statement 15

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Athletics','M','Men''s 10,000m','Bronze','ETH','TOLA Tamirat')

1 row(s) inserted.

Statement 16

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Athletics','M','Men''s 10,000m','Silver','KEN','TANUI Paul Kipngetich')

1 row(s) inserted.

Statement 17

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Athletics','M','Men''s 100m','Gold','JAM','BOLT Usain')

1 row(s) inserted.

Statement 18

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Athletics','M','Men''s 100m','Silver','USA','GATLIN Justin')

1 row(s) inserted.

Statement 19

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Athletics','M','Men''s 100m','Bronze','CAN','DE GRASSE Andre')

1 row(s) inserted.

Statement 20

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Gold','CHN','Zhang')

1 row(s) inserted.

Statement 21

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Bronze','GBR','Langridge')

1 row(s) inserted.

Statement 22

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Bronze','GBR','Ellis')

1 row(s) inserted.

Statement 23

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Silver','MAS','Tan')

1 row(s) inserted.

Statement 24

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Silver','MAS','Goh')

1 row(s) inserted.

Statement 25

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Badminton','M','Men''s Doubles','Gold','CHN','Fu')

1 row(s) inserted.

Statement 26

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Beach Volleyball','M','Men','Gold','BRA','Cerutti')

1 row(s) inserted.

Statement 27

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Beach Volleyball','M','Men','Gold','BRA','Oscar Schmidt')

1 row(s) inserted.

Statement 28

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Beach Volleyball','M','Men','Silver','ITA','Nicolai')

1 row(s) inserted.

Statement 29

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Beach Volleyball','M','Men','Silver','ITA','Lupo')

1 row(s) inserted.

Statement 30

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Beach Volleyball','M','Men','Bronze','NED','Meeuwsen')

1 row(s) inserted.

Statement 31

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Beach Volleyball','M','Men','Bronze','NED','Brouwer')

1 row(s) inserted.

Statement 32

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

1 row(s) inserted.

Statement 33

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

1 row(s) inserted.

Statement 34

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

1 row(s) inserted.

Statement 35

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

1 row(s) inserted.

Statement 36

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Boxing','M','Men''s Fly (52kg)','Gold','UZB','ZOIROV Shakhobidin')

1 row(s) inserted.

Statement 37

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Boxing','M','Men''s Fly (52kg)','Bronze','CHN','HU Jianguan')

1 row(s) inserted.

Statement 38

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

1 row(s) inserted.

Statement 39

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

1 row(s) inserted.

Statement 40

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

1 row(s) inserted.

Statement 41

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

1 row(s) inserted.

Statement 42

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

1 row(s) inserted.

Statement 43

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

1 row(s) inserted.

Statement 44

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Gold','GER','Brendel')

1 row(s) inserted.

Statement 45

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Bronze','UKR','Mishchuk')

1 row(s) inserted.

Statement 46

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Bronze','UKR','Ianchuk')

1 row(s) inserted.

Statement 47

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Silver','BRA','Queiroz dos Santos')

1 row(s) inserted.

Statement 48

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Silver','BRA','de Souza Silva')

1 row(s) inserted.

Statement 49

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Canoe Sprint','M','Men''s Canoe Double 1000m','Gold','GER','Vandrey')

1 row(s) inserted.

Statement 50

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

1 row(s) inserted.

Statement 51

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

1 row(s) inserted.

Statement 52

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

1 row(s) inserted.

Statement 53

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

1 row(s) inserted.

Statement 54

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Cycling Road','M','Men''s Road Race','Silver','DEN','FUGLSANG Jakob')

1 row(s) inserted.

Statement 55

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Cycling Road','M','Men''s Road Race','Bronze','POL','MAJKA Rafal')

1 row(s) inserted.

Statement 56

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

1 row(s) inserted.

Statement 57

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

1 row(s) inserted.

Statement 58

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

1 row(s) inserted.

Statement 59

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

1 row(s) inserted.

Statement 60

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

1 row(s) inserted.

Statement 61

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

1 row(s) inserted.

Statement 62

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Diving','M','Men''s 10m Platform','Gold','CHN','CHEN Aisen')

1 row(s) inserted.

Statement 63

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

1 row(s) inserted.

Statement 64

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

1 row(s) inserted.

Statement 65

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

1 row(s) inserted.

Statement 66

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

1 row(s) inserted.

Statement 67

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

1 row(s) inserted.

Statement 68

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Equestrian','X','Dressage Individual','Gold','GBR','DUJARDIN Charlotte')

1 row(s) inserted.

Statement 69

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Equestrian','X','Dressage Individual','Bronze','GER','BRORING-SPREHE Kristina')

1 row(s) inserted.

Statement 70

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Equestrian','X','Dressage Individual','Silver','GER','WERTH Isabell')

1 row(s) inserted.

Statement 71

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Equestrian','X','Dressage Team','Gold','GER','Germany')

1 row(s) inserted.

Statement 72

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Equestrian','X','Dressage Team','Bronze','USA','United States')

1 row(s) inserted.

Statement 73

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Equestrian','X','Dressage Team','Silver','GBR','Great Britain')

1 row(s) inserted.

Statement 74

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

1 row(s) inserted.

Statement 75

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Fencing','M','Men''s Foil Individual','Silver','USA','MASSIALAS Alexander')

1 row(s) inserted.

Statement 76

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Fencing','M','Men''s Foil Individual','Bronze','RUS','SAFIN Timur')

1 row(s) inserted.

Statement 77

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Fencing','M','Men''s Foil Team','Gold','RUS','Russian Federation')

1 row(s) inserted.

Statement 78

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Fencing','M','Men''s Foil Team','Bronze','USA','United States')

1 row(s) inserted.

Statement 79

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Fencing','M','Men''s Foil Team','Silver','FRA','France')

1 row(s) inserted.

Statement 80

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Handball','M','Men','Gold','DEN','Denmark')

1 row(s) inserted.

Statement 81

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Handball','M','Men','Silver','FRA','France')

1 row(s) inserted.

Statement 82

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Handball','M','Men','Bronze','GER','Germany')

1 row(s) inserted.

Statement 83

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Handball','W','Women','Gold','RUS','Russian Federation')

1 row(s) inserted.

Statement 84

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Handball','W','Women','Silver','FRA','France')

1 row(s) inserted.

Statement 85

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Handball','W','Women','Bronze','NOR','Norway')

1 row(s) inserted.

Statement 86

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Hockey','M','Men','Gold','ARG','Argentina')

1 row(s) inserted.

Statement 87

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Hockey','M','Men','Silver','BEL','Belgium')

1 row(s) inserted.

Statement 88

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Hockey','M','Men','Bronze','GER','Germany')

1 row(s) inserted.

Statement 89

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Hockey','W','Women','Gold','GBR','Great Britain')

1 row(s) inserted.

Statement 90

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Hockey','W','Women','Silver','NED','Netherlands')

1 row(s) inserted.

Statement 91

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Hockey','W','Women','Bronze','GER','Germany')

1 row(s) inserted.

Statement 92

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

1 row(s) inserted.

Statement 93

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Judo','M','Men +100 kg','Bronze','BRA','SILVA Rafael')

1 row(s) inserted.

Statement 94

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

1 row(s) inserted.

Statement 95

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

1 row(s) inserted.

Statement 96

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Judo','M','Men -100 kg','Gold','CZE','KRPALEK Lukas')

1 row(s) inserted.

Statement 97

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Judo','M','Men -100 kg','Bronze','FRA','MARET Cyrille')

1 row(s) inserted.

Statement 98

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

1 row(s) inserted.

Statement 99

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Modern Pentathlon','M','Men''s Individual','Silver','UKR','TYMOSHCHENKO Pavlo')

1 row(s) inserted.

Statement 100

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Modern Pentathlon','M','Men''s Individual','Bronze','MEX','HERNANDEZ USCANGA Ismael Marcelo')

1 row(s) inserted.

Statement 101

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Modern Pentathlon','W','Women''s Individual','Gold','AUS','ESPOSITO Chloe')

1 row(s) inserted.

Statement 102

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Modern Pentathlon','W','Women''s Individual','Silver','FRA','CLOUVEL Elodie')

1 row(s) inserted.

Statement 103

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Modern Pentathlon','W','Women''s Individual','Bronze','POL','NOWACKA Oktawia')

1 row(s) inserted.

Statement 104

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

1 row(s) inserted.

Statement 105

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Group All-Around','Bronze','BUL','Bulgaria')

1 row(s) inserted.

Statement 106

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rhythmic Gymnastics','W','Group All-Around','Silver','ESP','Spain')

1 row(s) inserted.

Statement 107

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

1 row(s) inserted.

Statement 108

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

1 row(s) inserted.

Statement 109

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

1 row(s) inserted.

Statement 110

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','Gold','FRA','Azou')

1 row(s) inserted.

Statement 111

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','Bronze','NOR','Brun')

1 row(s) inserted.

Statement 112

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','Bronze','NOR','Strandli')

1 row(s) inserted.

Statement 113

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','Silver','IRL','O''Donovan')

1 row(s) inserted.

Statement 114

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','Silver','IRL','O''Donovan')

1 row(s) inserted.

Statement 115

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Rowing','M','Lightweight Men''s Double Sculls','Gold','FRA','Houin')

1 row(s) inserted.

Statement 116

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Sailing','M','470 Men','Gold','CRO','Fantela')

1 row(s) inserted.

Statement 117

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Sailing','M','470 Men','Bronze','GRE','Kagialis')

1 row(s) inserted.

Statement 118

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Sailing','M','470 Men','Bronze','GRE','Mantis')

1 row(s) inserted.

Statement 119

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Sailing','M','470 Men','Silver','AUS','Ryan')

1 row(s) inserted.

Statement 120

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Sailing','M','470 Men','Silver','AUS','Belcher')

1 row(s) inserted.

Statement 121

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Sailing','M','470 Men','Gold','CRO','Marenic')

1 row(s) inserted.

Statement 122

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Swimming','M','Men''s 100m Backstroke','Gold','USA','MURPHY Ryan')

1 row(s) inserted.

Statement 123

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

1 row(s) inserted.

Statement 124

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

1 row(s) inserted.

Statement 125

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

1 row(s) inserted.

Statement 126

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

1 row(s) inserted.

Statement 127

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

1 row(s) inserted.

Statement 128

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

1 row(s) inserted.

Statement 129

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

1 row(s) inserted.

Statement 130

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

1 row(s) inserted.

Statement 131

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Table Tennis','M','Men''s Team','Gold','CHN','China')

1 row(s) inserted.

Statement 132

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Table Tennis','M','Men''s Team','Bronze','GER','Germany')

1 row(s) inserted.

Statement 133

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Table Tennis','M','Men''s Team','Silver','JPN','Japan')

1 row(s) inserted.

Statement 134

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Gold','AZE','ISAEV Radik')

1 row(s) inserted.

Statement 135

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Bronze','KOR','CHA Dongmin')

1 row(s) inserted.

Statement 136

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Bronze','BRA','SIQUEIRA Maicon')

1 row(s) inserted.

Statement 137

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Taekwondo','M','Men +80kg','Silver','NIG','ISSOUFOU ALFAGA Abdoulrazak')

1 row(s) inserted.

Statement 138

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Taekwondo','M','Men -58kg','Gold','CHN','ZHAO Shuai')

1 row(s) inserted.

Statement 139

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Taekwondo','M','Men -58kg','Silver','THA','HANPRAB Tawin')

1 row(s) inserted.

Statement 140

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Gold','ESP','Lopez')

1 row(s) inserted.

Statement 141

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Bronze','USA','Johnson')

1 row(s) inserted.

Statement 142

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Bronze','USA','Sock')

1 row(s) inserted.

Statement 143

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Silver','ROU','Tecau')

1 row(s) inserted.

Statement 144

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Silver','ROU','Mergea')

1 row(s) inserted.

Statement 145

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Tennis','M','Men''s Doubles','Gold','ESP','Nadal')

1 row(s) inserted.

Statement 146

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Trampoline Gymnastics','M','Men','Gold','BLR','HANCHAROU Uladzislau')

1 row(s) inserted.

Statement 147

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Trampoline Gymnastics','M','Men','Silver','CHN','DONG Dong')

1 row(s) inserted.

Statement 148

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Trampoline Gymnastics','M','Men','Bronze','CHN','GAO Lei')

1 row(s) inserted.

Statement 149

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Trampoline Gymnastics','W','Women','Gold','CAN','MACLENNAN Rosannagh')

1 row(s) inserted.

Statement 150

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Trampoline Gymnastics','W','Women','Silver','GBR','PAGE Bryony')

1 row(s) inserted.

Statement 151

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Trampoline Gymnastics','W','Women','Bronze','CHN','LI Dan')

1 row(s) inserted.

Statement 152

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Triathlon','M','Men','Gold','GBR','BROWNLEE Alistair')

1 row(s) inserted.

Statement 153

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Triathlon','M','Men','Silver','GBR','BROWNLEE Jonathan')

1 row(s) inserted.

Statement 154

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Triathlon','M','Men','Bronze','RSA','SCHOEMAN Henri')

1 row(s) inserted.

Statement 155

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Triathlon','W','Women','Gold','USA','JORGENSEN Gwen')

1 row(s) inserted.

Statement 156

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Triathlon','W','Women','Silver','SUI','SPIRIG HUG Nicola')

1 row(s) inserted.

Statement 157

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Triathlon','W','Women','Bronze','GBR','HOLLAND Vicky')

1 row(s) inserted.

Statement 158

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Volleyball','M','Men','Gold','BRA','Brazil')

1 row(s) inserted.

Statement 159

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Volleyball','M','Men','Silver','ITA','Italy')

1 row(s) inserted.

Statement 160

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Volleyball','M','Men','Bronze','USA','United States')

1 row(s) inserted.

Statement 161

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Volleyball','W','Women','Gold','CHN','China')

1 row(s) inserted.

Statement 162

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Volleyball','W','Women','Silver','SRB','Serbia')

1 row(s) inserted.

Statement 163

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Volleyball','W','Women','Bronze','USA','United States')

1 row(s) inserted.

Statement 164

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Water Polo','M','Men','Gold','SRB','Serbia')

1 row(s) inserted.

Statement 165

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Water Polo','M','Men','Silver','CRO','Croatia')

1 row(s) inserted.

Statement 166

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Water Polo','M','Men','Bronze','ITA','Italy')

1 row(s) inserted.

Statement 167

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Water Polo','W','Women','Gold','USA','United States')

1 row(s) inserted.

Statement 168

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Water Polo','W','Women','Silver','ITA','Italy')

1 row(s) inserted.

Statement 169

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Water Polo','W','Women','Bronze','RUS','Russian Federation')

1 row(s) inserted.

Statement 170

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

1 row(s) inserted.

Statement 171

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

1 row(s) inserted.

Statement 172

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

1 row(s) inserted.

Statement 173

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Weightlifting','M','Men''s 105kg','Gold','UZB','NURUDINOV Ruslan')

1 row(s) inserted.

Statement 174

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

1 row(s) inserted.

Statement 175

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

1 row(s) inserted.

Statement 176

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

1 row(s) inserted.

Statement 177

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

1 row(s) inserted.

Statement 178

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

1 row(s) inserted.

Statement 179

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

1 row(s) inserted.

Statement 180

Insert into olympic_medal_winners (OLYMPIC_YEAR,SPORT,GENDER,EVENT,MEDAL,NOC,ATHLETE) values (2016,'Wrestling','M','Men''s Freestyle 57 kg','Gold','GEO','KHINCHEGASHVILI Vladimer')

1 row(s) inserted.

Statement 181

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

1 row(s) inserted.

Statement 182

This pivots the 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   
))   
order by noc   
fetch first 6 rows only

OLYMPIC_YEAR	SPORT	GENDER	EVENT	NOC	ATHLETE	GOLD	SILVER	BRONZE
2016	Hockey	M	Men	ARG	Argentina	1	0	0
2016	Weightlifting	M	Men's +105kg	ARM	MINASYAN Gor	0	1	0
2016	Weightlifting	M	Men's 105kg	ARM	MARTIROSYAN Simon	0	1	0
2016	Archery	M	Men's Team	AUS	Australia	0	0	1
2016	Modern Pentathlon	W	Women's Individual	AUS	ESPOSITO Chloe	1	0	0
2016	Sailing	M	470 Men	AUS	Belcher	0	1	0

6 rows selected.

Statement 183

To overcome the problem in the previous statement, this selects just the columns you need in the subquery. But some events have multiple people who win the same medal - e.g. doubles tennis. This pivot counts rows in the table, not individual events.

select * from (   
 select noc, medal from olympic_medal_winners   
)   
pivot ( count(*) for medal in (   
 'Gold' gold, 'Silver' silver, 'Bronze' bronze   
))   
order  by 2 desc, 3 desc, 4 desc   
fetch first 5 rows only

NOC	GOLD	SILVER	BRONZE
CHN	8	3	3
GBR	7	7	5
RUS	5	1	3
GER	4	1	6
USA	3	5	10

5 rows selected.

Statement 184

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   
)   
pivot ( count(distinct sport ||'#'|| event ||'#'||gender ) for medal in (   
 'Gold' gold, 'Silver' silver, 'Bronze' bronze   
))   
order  by 2 desc, 3 desc, 4 desc   
fetch first 5 rows only

NOC	GOLD	SILVER	BRONZE
GBR	7	6	4
CHN	7	3	3
RUS	5	1	3
USA	3	5	9
GER	3	1	6

5 rows selected.

Statement 185

You can have many functions in the pivot. Oracle generates a column for each function per value in the in clause. This finds the gold medal winning countries. For each it shows: - The number of different events these were won in - The number of different sports thy were won in - The names of the athlete or team who won each medal Finally it filters to only show those countries that won at least two gold medals.

select * from (   
  select noc, medal, sport, event, gender, athlete   
  from   olympic_medal_winners   
)   
pivot  (    
  count( distinct sport ||'#'|| event ||'#'|| gender ) medals,   
  count( distinct sport ) sports,   
  listagg( athlete, ',') within group (order by athlete) athletes   
  for medal in ( 'Gold' gold )   
)   
where  gold_medals > 1   
order  by gold_medals, gold_sports, noc   
fetch  first 5 rows only

NOC	GOLD_MEDALS	GOLD_SPORTS	GOLD_ATHLETES
KOR	2	1	KU Bonchan,Republic of Korea
BRA	2	2	Brazil,Cerutti,Oscar Schmidt
FRA	2	2	Azou,Houin,RINER Teddy
GEO	2	2	KHINCHEGASHVILI Vladimer,TALAKHADZE Lasha
ITA	2	2	GAROZZO Daniele,VIVIANI Elia

5 rows selected.

Statement 186

This is similar to the previous query. But it finds those countries whose IOC code starts with D.

select * from (   
  select noc, medal, sport, event, gender, athlete   
  from   olympic_medal_winners   
)   
pivot  (    
  count( distinct sport ||'#'|| event ||'#'|| gender ) medals,   
  count( distinct sport ) sports,   
  listagg( athlete, ',') within group (order by athlete) athletes   
  for medal in ( 'Gold' gold )   
)   
where  noc like 'D%'   
order  by gold_medals

NOC	GOLD_MEDALS	GOLD_SPORTS	GOLD_ATHLETES
DEN	1	1	Denmark

Statement 187

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

select * from (     
  select noc, sport     
  from   olympic_medal_winners     
)     
pivot (min('X') for sport in (     
  'Archery' as arc, 'Athletics' as ath, 'Hockey' as hoc,   
  'Judo' as jud, 'Sailing' as sai, 'Wrestling' as wre  
  )      
)     
order  by noc     
fetch  first 7 rows only

NOC	ARC	ATH	HOC	JUD	SAI	WRE
ARG	-	-	X	-	-	-
ARM	-	-	-	-	-	-
AUS	X	-	-	-	X	-
AZE	-	-	-	-	-	X
BEL	-	-	X	-	-	-
BLR	-	-	-	-	-	X
BRA	-	-	-	X	-	-

7 rows selected.

Statement 188

This is the old school, pre Oracle Database 11g method for pivoting data.

select noc,    
       count ( case when medal = 'Gold' then 1 end ) gold_medals,    
       count ( case when medal = 'Silver' then 1 end ) silver_medals,    
       count ( case when medal = 'Bronze' then 1 end ) bronze_medals   
from   olympic_medal_winners   
group  by noc   
order  by 2 desc, 3 desc, 4 desc   
fetch first 5 rows only

NOC	GOLD_MEDALS	SILVER_MEDALS	BRONZE_MEDALS
CHN	8	3	3
GBR	7	7	5
RUS	5	1	3
GER	4	1	6
USA	3	5	10

5 rows selected.

Statement 189

An example of how to build the pivot clause values dynamically. Note that when you do this the number of columns can change between runs. So the execute and fetch routine will be far more complex in a real world scenario!

declare   
  sql_stmt     clob;   
  pivot_clause clob;   
begin   
  select listagg('''' || sport || ''' as "' || sport || '"', ',') within group (order by sport)    
  into   pivot_clause   
  from   (select distinct sport from olympic_medal_winners);   
   
  sql_stmt := 'select * from (select noc, sport from olympic_medal_winners)   
pivot (count(*) for sport in (' || pivot_clause || '))';   
   
  dbms_output.put_line( sql_stmt );   
   
  execute immediate sql_stmt;   
end;

select * from (select noc, sport from olympic_medal_winners) pivot (count(*) for sport in ('Archery' as "Archery",'Artistic Gymnastics' as "Artistic Gymnastics",'Athletics' as "Athletics",'Badminton' as "Badminton",'Beach Volleyball' as "Beach Volleyball",'Boxing' as "Boxing",'Canoe Slalom' as "Canoe Slalom",'Canoe Sprint' as "Canoe Sprint",'Cycling Road' as "Cycling Road",'Cycling Track' as "Cycling Track",'Diving' as "Diving",'Equestrian' as "Equestrian",'Fencing' as "Fencing",'Handball' as "Handball",'Hockey' as "Hockey",'Judo' as "Judo",'Modern Pentathlon' as "Modern Pentathlon",'Rhythmic Gymnastics' as "Rhythmic Gymnastics",'Rowing' as "Rowing",'Sailing' as "Sailing",'Swimming' as "Swimming",'Table Tennis' as "Table Tennis",'Taekwondo' as "Taekwondo",'Tennis' as "Tennis",'Trampoline Gymnastics' as "Trampoline Gymnastics",'Triathlon' as "Triathlon",'Volleyball' as "Volleyball",'Water Polo' as "Water Polo",'Weightlifting' as "Weightlifting",'Wrestling' as "Wrestling"))

Statement 190

The XML keyword dynamically builds the list of values to pivot. But you get the results in XML! Each "column" is an element in this document.

select * from (   
 select noc, sport   
 from   olympic_medal_winners   
)   
pivot xml (count(*) medal_winners for sport in (   
 select sport   
 from   olympic_medal_winners   
 where  sport like 'A%')    
)   
where rownum = 1

NOC	SPORT_XML
ARG	<PivotSet><item><column name = "SPORT">Archery</column><column name = "MEDAL_WINNERS">1</column></item><item><column name = "SPORT">Artistic Gymnastics</column><column name = "MEDAL_WINNERS">1</column></item><item><column name = "SPORT">Athletics</column><column name = "MEDAL_WINNERS">1</column></item></PivotSet>

Statement 191

This previous example gave every country at least one medal in every sport! To avoid this, you need to count a column which will be null if the country didn't win in a particular event.

select * from (   
 select noc, sport, athlete   
 from olympic_medal_winners   
)   
pivot xml (count(athlete) medal_winners for sport in (   
 select sport   
 from   olympic_medal_winners   
 where  sport like 'A%')    
)   
where rownum = 1

NOC	SPORT_XML
ARG	<PivotSet><item><column name = "SPORT">Archery</column><column name = "MEDAL_WINNERS">0</column></item><item><column name = "SPORT">Artistic Gymnastics</column><column name = "MEDAL_WINNERS">0</column></item><item><column name = "SPORT">Athletics</column><column name = "MEDAL_WINNERS">0</column></item></PivotSet>

Statement 192

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

create table olympic_medal_tables as   
select * from (   
 select noc, medal, sport, event, gender   
 from olympic_medal_winners   
)   
pivot ( count(distinct sport ||'#'|| event ||'#'||gender ) for medal in (   
 'Gold' gold_medals, 'Silver' silver_medals, 'Bronze' bronze_medals   
))   
order  by 2 desc, 3 desc, 4 desc

Table created.

Statement 193

Unpivot takes the columns and converts them back to rows.

select * from olympic_medal_tables   
unpivot (medal_count for medal_colour in (   
  gold_medals as 'GOLD',   
  silver_medals as 'SILVER',   
  bronze_medals as 'BRONZE'   
))   
order  by noc   
fetch  first 6 rows only

NOC	MEDAL_COLOUR	MEDAL_COUNT
ARG	GOLD	1
ARG	BRONZE	0
ARG	SILVER	0
ARM	GOLD	0
ARM	BRONZE	0
ARM	SILVER	2

6 rows selected.

Statement 194

drop table olympic_medal_tables purge

Table dropped.

Statement 195

create table olympic_medal_tables as  
select * from (  
 select noc, medal, sport, event, gender  
 from olympic_medal_winners  
)  
pivot ( count(distinct sport ||'#'|| event ||'#'||gender ) medals,   
  count(distinct sport) sports  
  for medal in (  
 'Gold' gold, 'Silver' silver, 'Bronze' bronze  
))  
order  by 2 desc, 4 desc, 6 desc

Table created.

Statement 196

You can unpivot two or more columns to a single row. To do this, provide a list of the columns you want to combine. You then get a column for each in the results.

select * from olympic_medal_tables   
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'   
))   
fetch first 9 rows only

NOC	MEDAL_COLOUR	MEDAL_COUNT	SPORT_COUNT
GBR	GOLD	7	7
GBR	SILVER	6	6
GBR	BRONZE	4	4
CHN	GOLD	7	5
CHN	SILVER	3	3
CHN	BRONZE	3	2
RUS	GOLD	5	4
RUS	SILVER	1	1
RUS	BRONZE	3	3

9 rows selected.

Statement 197

drop table olympic_medal_tables purge

Table dropped.

Statement 198

create table olympic_medal_tables as  
select * from (  
 select noc, medal, sport, event, gender, athlete  
 from olympic_medal_winners  
)  
pivot ( count(distinct sport ||'#'|| event ||'#'||gender ) medals,   
  listagg(athlete, ',') within group (order by athlete) athletes  
  for medal in (  
 'Gold' gold, 'Silver' silver, 'Bronze' bronze  
))  
order  by 2 desc, 4 desc, 6 desc

Table created.

Statement 199

Another example of unpivoting multiple columns. This time with a list of athletes.

select * from olympic_medal_tables   
unpivot ((medal_count, athletes) for medal_colour in (   
  (gold_medals, gold_athletes) as 'GOLD',    
  (silver_medals, silver_athletes) as 'SILVER',    
  (bronze_medals, bronze_athletes) as 'BRONZE'   
))   
where  medal_colour = 'GOLD'   
and    medal_count = 2   
order  by noc   
fetch first 3 rows only

NOC	MEDAL_COLOUR	MEDAL_COUNT	ATHLETES
BRA	GOLD	2	Brazil,Cerutti,Oscar Schmidt
FRA	GOLD	2	Azou,Houin,RINER Teddy
GEO	GOLD	2	KHINCHEGASHVILI Vladimer,TALAKHADZE Lasha

3 rows selected.

Statement 200

This first unpivots the results to get the list of athletes won two gold medals. It then uses XML tokenization to split the list into a row per person.

with rws as (   
  select * from olympic_medal_tables   
  unpivot ((medal_count, athletes) for medal_colour in (   
    (gold_medals, gold_athletes) as 'GOLD',    
    (silver_medals, silver_athletes) as 'SILVER',    
    (bronze_medals, bronze_athletes) as 'BRONZE'   
  ))   
  where  medal_colour = 'GOLD'   
  and    medal_count = 2   
)   
  select noc, athlete   
  from   rws, xmltable (   
    'if (contains($X,",")) then ora:tokenize($X,"\,") else $X'   
    passing athletes as X   
    columns athlete varchar2(4000) path '.'   
  )   
  order  by 1, 2   
  fetch first 6 rows only

NOC	ATHLETE
BRA	Brazil
BRA	Cerutti
BRA	Oscar Schmidt
FRA	Azou
FRA	Houin
FRA	RINER Teddy

6 rows selected.

Statement 201

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   
)   
pivot (count(sport) for sport in (   
  'Athletics' as ath, 'Artistic Gymnastics' as gym, 'Cycling Track' as cyc,  
  'Boxing' as box, 'Sailing' as sai  
  )    
)   
order  by 1

Table created.

Statement 202

This switches the rows and columns over aka a transpose. It does so by chaining a pivot followed by an unpivot.

select * from olympic_country_sport_medals   
pivot  (   
  sum(ath) ath, sum(box) box, sum(gym) gym, sum(sai) sai, sum(cyc) cyc   
  for noc in ('BRA' BRA, 'CHN' CHN, 'DEN' DEN, 'ESP' ESP, 'ETH' ETH, 'GRE' GRE )   
)   
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'   
  )   
)

5 rows selected.

Statement 203

Tranposing data using unpivot and pivot. Much easier to write than the other way around!

select * from olympic_country_sport_medals   
unpivot (   
  (medals) for sport in ( ath, box, gym, sai, cyc )   
)   
pivot  (   
  sum(medals) for noc in (   
    'BRA' BRA, 'CHN' CHN, 'DEN' DEN, 'ESP' ESP, 'ETH' ETH, 'GRE' GRE  
  )   
)

5 rows selected.

NOC	ARC	ATH	HOC	JUD	SAI	WRE
ARG	-	-	X	-	-	-
ARM	-	-	-	-	-	-
AUS	X	-	-	-	X	-
AZE	-	-	-	-	-	X
BEL	-	-	X	-	-	-
BLR	-	-	-	-	-	X
BRA	-	-	-	X	-	-

NOC	ARC	ATH	HOC	JUD	SAI	WRE
ARG	-	-	X	-	-	-
ARM	-	-	-	-	-	-
AUS	X	-	-	-	X	-
AZE	-	-	-	-	-	X
BEL	-	-	X	-	-	-
BLR	-	-	-	-	-	X
BRA	-	-	-	X	-	-

Artistic Gym

Track Cycling

NOC	ARC	ATH	HOC	JUD	SAI	WRE
ARG	-	-	X	-	-	-
ARM	-	-	-	-	-	-
AUS	X	-	-	-	X	-
AZE	-	-	-	-	-	X
BEL	-	-	X	-	-	-
BLR	-	-	-	-	-	X
BRA	-	-	-	X	-	-