english deutsch

Training

Tabellen des gewählten Szenarios
Tabelle Spalten Fremdschlüssel
athlete ( aid , name , gender )
athlete_team ( aid , tid , gid )
aid » athlete.aid
tid » team.tid
gid » games.gid
discipline ( did , sid , name )
sid » sport.sid
games ( gid , year , season , city )
medals ( aid , gid , did , age , height , weight , medal )
aid » athlete.aid
gid » games.gid
did » discipline.did
sport ( sid , name )
team ( tid , noc , team )
DB: PostgreSQL     Legende: TABELLE, PRIMÄRSCHLÜSSEL, FREMDSCHLÜSSEL
Olympic (Prof. Schiefer) → Einfache Abfragen → Aufgabe 1.5
Aufgabe Finde die Teams und ihre zugehörigen NOC-Codes.
SQL Query
 
Ausgabe der Musterlösung — Datensätze : 1231
team_name noc_code
Falcon VI AUS
Grifone ITA
Titia GBR
Sidi-Fekkar-14 FRA
South Sudan SSD
Heidelberg URU
Crabe I-2 FRA
Moseley Wanderers GBR
Skidoo USA
Saint Vincent and the Grenadines VIN
Sif SWE
Astrid III FRA
Slovakia-2 SVK
Holland NED
Roma ITA
Vietnam VIE
Pettit-Poucet-6 FRA
Taifun URS
Skum DEN
Paraguay PAR
Norway-3 NOR
Cornwall GBR
Matrero II ARG
Germania Ruder Club, Hamburg GER
Tlaloc MEX
Sjovinge SWE
USFSA FRA
Ali-Baba IV SUI
Pousse-Moi Pas VII SUI
Ghana GHA
Phalainis ton Thorichtou "Psara"-3 GRE
Lucky Star FIN
Chad CHA
Covunco III ARG
Mythilus USA
Ormsund Roklub-2 NOR
Malta MLT
Rififi FIN
Osborne Swimming Club, Manchester NZL
Relampago AUS
Libellule de Paris GBR
Naiad AUS
Bucintoro Venezia-1 ITA
Buscape II BRA
Tip DEN
Namoussa FRA
Ukraine UKR
Gambia GAM
Widgeon USA
Barion/Bari-2 ITA
Beaver CAN
Portugal-2 POR
Antigua and Barbuda ANT
Mascaret-4 FRA
Jamaica-1 JAM
France/Great Britain FRA
Nadine NED
Germany-2 GER
Maid of Lebanon LIB
Lynn FIN
Damoiselle IV MON
Yeoman V RSA
Donar III AUT
Sirene NOR
Quando Quando AUS
Three Leaves IRL
New College, Oxford-2 GBR
Swaziland SWZ
Amstel Amsterdam NED
Vinga-1 SWE
Gitana-2 FRA
Snowten III FRA
West Indies Federation WIF
Galejan SWE
Leander Club-1 GBR
Norway-2 NOR
Cuxhaven TUR
Teresita FIN
St. Rose-2 USA
Kurush II CUB
Whisper JPN
Bonaparte GER
Swedish Star SWE
Egypt EGY
Posillipo III ESP
Great Britain/Germany GER
Leander Club #1-1 GBR
MitaII JPN
St. Margrite NED
Ravenswood Boat Club-2 USA
Brazil-2 BRA
Philippines PHI
Solos Carex SWE
Espardate POR
England GBR
United States-5 USA
Finland-2 FIN
Merope MLT
Montenegro MNE
Cape Verde CPV
Rose Pompon FRA
Tantalus GER
Irene NOR
Pam BER
BLO Polo Club, Rugby USA
Aloha II FRA
Lett NOR
Chinese Taipei-2 TPE
Israel ISR
White Lady DEN
North Korea PRK
Crete CRT
Orion CAN
Mascaret-28 FRA
Luxembourg-1 LUX
Venezuela VEN
Balaton HUN
Carabinier-5 FRA
Ireland GBR
Amulet-7 FRA
Turnverein Vorwrts, Chicago USA
Malaysia MAS
Paka V GER
Denmark-3 DEN
Japan-1 JPN
Pan NOR
South Africa-1 RSA
Hb-20 FRA
Formosa USA
Atalanta Boat Club-1 USA
Iran IRI
Unknown UNK
Galt Football Club CAN
Nigeria-2 NGR
United Arab Republic UAR
Chinese Taipei-1 TPE
Partenope INA
Uzbekistan UZB
Thames Rowing Club GBR
Thailand THA
Bulgaria-2 BUL
Macky VI GER
Gwendoline-22 FRA
Spirit VI USA
Sweden-3 SWE
Alcaid POR
Tutti V EST
Univ. of Brussels NED
Legionario ITA
El Salvador ESA
Roddklubben af 1912-2 SWE
Ciocca ITA
Vicking POR
Crabe I-11 FRA
China CHN
Bylina-2 RUS
United States-11 USA
Chile CHI
Grifo IV POR
Scamasaxe-2 FRA
May Be SWE
Denmark-1 DEN
Lbeck BRA
Sandra FRA
Gteborgs Roddklubb-1 SWE
Oleander II BER
Rush V SWE
Venilia ITA
Boreas JPN
Akatonbo IRL
Saga-2 SWE
Grifo III POR
Canopus POR
A North American Team USA
Meteor BEL
Societ Nautique de la Marne-1 FRA
Evita VI AUT
Mexico-1 MEX
Windor CAN
Brandenburg EST
Bulgaria-1 BUL
Frieda USA
Alcyon-7 FRA
Proteus II GRE
South Korea-1 KOR
Femur-18 FRA
Syria SYR
Japan JPN
Sunshine SWE
Finn II FIN
Yeoman XII GBR
Palau PLW
Ma'Lindo POR
Kyrgyzstan KGZ
Elvis Va GER
Pierre et Jean-3 FRA
Aphrodite USA
Digby DEN
Brussels Swimming and Water Polo Club BEL
Eritrea ERI
Germania II GER
Marshall Islands MHL
Lalage BEL
Voloira II ITA
Slovakia-1 SVK
Lalage GBR
Solomon Islands SOL
Lebanon LIB
Trans-Mississippi Golf Association-2 USA
Santa Maria CAN
Antares ARG
Ireland IRL
Great Britain-2 GBR
Soviet Union-2 URS
Breslau AUT
Nurdug II DEN
Olle FRA
Bulgaria BUL
Gyrinus-1 GBR
Norna NOR
Laurea-1 GBR
Briar SWE
Web II DEN
Monaco-1 MON
Potsdam GBR
Bona Fide GBR
Hungary-2 HUN
Tu-Fri FIN
Gabon GAB
Germany-1 GER
Guinea Bissau GBS
Stella-2 NOR
Camelia POR
Saar SAA
Sweden-1 SWE
Turkey TUR
Azerbaijan AZE
Omilos Ereton Peiraios-2 GRE
Marsouin-26 FRA
Hurlingham-2 GBR
Diabolo St Maurice FRA
Bajazzo URU
Alcyon-6 FRA
Rozenn-3 FRA
rn-2 FIN
Italy ITA
Qu'Importe FRA
Bohemia/Great Britain BOH
Davenport Turngemeinde, Davenport USA
Freja SWE
Romania-2 ROU
Jordan JOR
St. Louis Southwest Turnverein #2-3 USA
Wolseley-Siddeley-1 GBR
Norwegian Rowing Association NOR
Hi-Hi DEN
Belarus-1 BLR
Tango ARG
New York Athletic Club-4 USA
Serendipity CAN
Inga-Lill XXXXIII FIN
Galopin De La Font POR
Chance SWE
Marmara TUR
New Zealand-1 NZL
West Germany-3 FRG
Zambia ZAM
Singapore-1 SGP
Arcturus ARG
Australia/Great Britain AUS
Diablo AUS
United States-9 USA
Smyrna GBR
Encore NOR
Hungary HUN
Mauritius MRI
Monaco MON
Baby-1 FRA
United States-2 USA
Fruits ESP
Rhythm USA
Poland-2 POL
Sibindi-2 GBR
Monica NOR
Ali-Baba II SUI
Elsie SWE
Australia/Great Britain GBR
Caprice CAN
Phalainis ton Thorichtou "Hydra"-2 GRE
Fram NOR
Sildra-1 NOR
Gem BAH
Bellatrix XIII GER
Pupilles de Neptune de Lille #1-3 FRA
Gustel X GER
Ralia FIN
John B BAH
Amolgavar ESP
Great Britain-1 GBR
Poland-3 POL
Kosovo KOS
Royal Club Nautique de Gand BEL
United States-7 USA
Lucky Star GBR
Souvenance FRA
Bermudian BER
Mad Dog CAN
Bahamas BAH
La Salle Turnverein, Chicago USA
Johan GBR
Girl Pat BEL
Tichiboo THA
Marmi II-1 NOR
Freddy BEL
Greece-3 GRE
New York Athletic Club USA
Symphony POR
EA II FRA
Spain-1 ESP
Slovenia-1 SLO
Clearwater DEN
Kerstin-1 SWE
Philadelphia Turngemeinde, Philadelphia USA
Tim-Tam III SUI
Manana CAN
Georgia GEO
Red Dragon NZL
Marinai della nave da guerra "Varese" ITA
Yugoslavia-1 YUG
Belgium BEL
Argeste ITA
Osborne Swimming Club, Manchester GBR
Uzbekistan-2 UZB
Belarus-2 BLR
Jet CAN
Senegal SEN
Apache NOR
Miss Denmark 1964 DEN
Dresden CAN
Federated States of Micronesia FSM
South St Louis Turnverein, St Louis GER
Papua New Guinea PNG
Czechoslovakia-3 TCH
Macedonia MKD
Ireland-1 IRL
Chaje II FIN
Russia RUS
Ireland-2 IRL
Trickson VI CAN
Ceres II GBR
Bem II NED
Cote d'Ivoire CIV
Life boat naval ship "Spetsai"-1 GRE
Cambria AUS
Hong Kong-1 HKG
Ciss BEL
Danzig BEL
Great Britain GBR
Kurush IV CUB
Czech Republic-2 CZE
Comoros COM
Sydney Rowing Club ANZ
Romania-1 ROU
United States Golf Association-3 USA
Argus POR
Kemphaan NED
Bohemia-3 BOH
Chicago Athletic Association-2 USA
Puerto Rico-1 PUR
Sans Atout-1 SWE
Nina FIN
Sunrise NED
Tornado URS
Slovenia-2 SLO
Slovakia SVK
Combine BAH
Israel-1 ISR
Foxhunters Hurlingham USA
Maryke AUS
Lyn-2 NOR
Magda IX NOR
France-1 FRA
Circus WIF
Soviet Union URS
Merope ITA
Barbados BAR
Saint Lucia LCA
North Korea-2 PRK
Crabe II-1 FRA
Joy NED
Croatia CRO
Soviet Union-1 URS
Olimpia HUN
Gustl XI GER
Essen JPN
East Germany-2 GDR
Norway NOR
Andorinha BRA
Gyp-6 FRA
Olen URS
Mauritius-1 MRI
Saint Kitts and Nevis SKN
Wiking ARG
Devon and Somerset Wanderers GBR
Iceland ISL
Vesper Boat Club USA
Palestine PLE
East Germany GDR
Berliner Ruderclub Sport-Borussia-1 GER
Nepal NEP
Inca BRA
Cobweb-1 GBR
Unified Team EUN
Union des Socits Franais de Sports Athletiques HAI
Sjhxa POR
Ukraine-2 UKR
Hojwa SWE
East Germany-3 GDR
India-2 IND
Poland POL
Gilliatt V FRA
Latvia-2 LAT
Frankfurt Club GER
Vinha AUS
Noreg NOR
Hatuey CUB
Ducky-16 FRA
Great Britain-4 GBR
Ylliam II SUI
Calcinhas POR
Bagatelle Polo Club, Paris GBR
Tanzania TAN
Societ Nautique de la Marne FRA
Turnverein Vorwrts, Cleveland USA
India-1 IND
Germania Ruder Club, Hamburg-2 GER
Rika II SGP
United States/France FRA
Germany-3 GER
Calimucho FRA
Vento Sul BRA
Argentina-1 ARG
Wales-4 GBR
Ariette-8 FRA
Beatrijs III-1 NED
Yemen YEM
Linglom THA
Pan-Hellenic Athletic Club GRE
Kazakhstan KAZ
Oranje NED
Netherlands Antilles AHO
Oman OMA
Lucky NOR
Ciocca III POR
Tritons Lillois-2 FRA
Somalia SOM
South Yemen YMD
Knigsberg HUN
United States-8 USA
Chicago Archers USA
Aruba ARU
Pakistan PAK
Canopus ESP
Potomac Archers USA
Netherlands-1 NED
Kiribati KIR
Congo (Brazzaville) CGO
Kuwait KUW
BLO Polo Club, Rugby GBR
Cinara-13 FRA
Complex II USA
Tineke USA
Union des Socits Franais de Sports Athletiques GBR
Bosnia and Herzegovina BIH
Shrew II USA
Univ. of Brussels GBR
Hollandia NED
Canada CAN
Mozambique MOZ
30. Februar AUT
Switzerland-1 SUI
Ariel CAN
Taifun NOR
Crabe II-12 FRA
Pop Art CAN
Danuta POL
Plume-Patte-5 FRA
Sudan SUD
Barrenjoey AUS
Socit Nautique de la Basse Seine-1 FRA
Serbia-1 SRB
Polyteknisk Roklub-1 DEN
Sweden SWE
Roklubb Kbnhavn-2 DEN
Turquoise-3 FRA
Israel-2 ISR
Equatorial Guinea GEQ
Suzy-2 BEL
Thalatta NED
Carabinier-15 FRA
Gteborgs Roddfrening-2 SWE
United States-14 USA
Argentina ARG
Century Boat Club-1 USA
Dormy-1 GBR
Boer Team RSA
Ludwigshafener Ruder Verein-1 GER
Yugoslavia-2 YUG
Marga-2 SWE
Clementine V BRA
Bangladesh BAN
LaBandera FRA
Chicago Athletic Association FRA
Terrible BRA
Monaco-2 MON
Fantlet-7 FRA
Marsouin-8 FRA
Jamaica JAM
Galerna ESP
Virginie FRA
Kristiania Roklub NOR
Guyana GUY
Newfoundland NFL
Vaxholm Roddklubb SWE
Bera NOR
Morena DEN
Fortuna GBR
Tengiri INA
Union des Socits Franais de Sports Athletiques USA
Bermudes BER
Tournade-40 FRA
Bella FIN
Brazil BRA
France-2 FRA
Gallia II RUS
Malaysia-2 MAS
Aretusa ITA
Hamburg NOR
Great Britain-3 GBR
Ireland-2 GBR
Cercle Nautique de Reims-4 FRA
Andromeda GBR
Dominican Republic DOM
Malaysia-1 MAS
Bahrain BRN
Frimousse USA
Calypse II FRA
Portugal POR
Scaup CAN
Pirouette-5 FRA
Large boat, Central Naval Prep School "Poros"-1 GRE
Gullvinge ARG
Galatea II ITA
Cyprus CYP
Indonesia INA
Edelweiss II-1 BEL
Fornebo NOR
Scotia GBR
Giselle-6 FRA
South Korea KOR
Dansk Idrts Forbund DEN
Pampero ARG
Aletta IRL
Unified Team-1 EUN
Turkmenistan TKM
Seychelles SEY
Brentina USA
Brigantia AUT
Aldebaran II ITA
Brazil-1 BRA
Allegro FRA
Denmark-2 DEN
Squid III FIN
Marie-Tim GRE
Stade Franais AC-2 FRA
Daisy NED
Uganda UGA
Rwanda RWA
Finland-1 FIN
Kalayaan PHI
Feo GBR
Gem III BAH
Helsingfors R. K. FIN
Bellatrix IX GER
Pannonia RC/National RC HUN
Sorais-2 GBR
Sao Tome and Principe STP
R.-V. Germania, Leitmeritz AUT
Struten NOR
Kristiania Roklub-1 NOR
Argentina-2 ARG
Berliner Ruderverein von 1876-2 GER
Brat GBR
Riccar JPN
Mound City Rowing Club-2 USA
Trinidad and Tobago TTO
Heira II NOR
Togo TOG
Omilos Ereton Smyrnis GBR
Cambridge University Boat Club-2 GBR
KNS NOR
West Germany-1 FRG
Morocco MAR
Dylan-2 GBR
Fantasio III SUI
Botswana BOT
Favorite Hammonia-3 GER
Scram CAN
Deutscher Schwimm Verband Berlin GER
Nautikos Omilos-3 GRE
Romolo ITA
Western Golf Association-1 USA
Laos LAO
Toronto Argonauts CAN
Netherlands NED
United States-1 USA
United States Virgin Islands-1 ISV
Mosk II NOR
Vision GBR
Comanche USA
Singapore SGP
Hirondelle MON
Verveine-19 FRA
Jeanette-25 FRA
Rhodesia RHO
May Be VII SWE
Bohemia-2 BOH
Ancora GBR
Japan-2 JPN
Hayama SWE
Ariette-10 FRA
New York Athletic Club #1-1 USA
Phoenix HKG
Mac Miche FRA
Paula AUS
Pegaso ITA
Belgium-4 BEL
Bamba ITA
Zefyros GRE
Scamasaxe-3 FRA
Twins II ITA
Vesania CUB
Omas Helliniki P. S. GRE
South Korea-2 KOR
Freia-5 FRA
Burundi BDI
Mirtala ITA
Vinha FIN
South Vietnam VNM
Berliner Ruderclub GER
Dominica DMA
Lully II NOR
Pandora NZL
Sierra Leone SLE
Hb-24 FRA
Uzbekistan-1 UZB
Panama PAN
Guanahani BAH
Whirlaway CAN
Luxembourg LUX
Seawanhaka Boat Club-1 USA
Club Nautique de Dieppe-5 FRA
Margaret USA
Surprise AUT
Ilderim SWE
Xolotl MEX
Paka GBR
Subbnboana GER
Italy-1 ITA
Scotland-3 GBR
Heroine GBR
Pasodoble ESP
Kln SUI
Crocodile-11 FRA
Guam GUM
Umberta V ITA
Lerina SUI
Humbug V SWE
Pupilles de Neptune de Lille #1-3 BEL
West Germany FRG
Refugee Olympic Athletes ROT
Bucintoro Venezia ITA
Ubu BEL
Mignon-29 FRA
Nausikaa 4 MEX
Faneca POR
Bhutan BHU
Singy-7 FRA
Czech Republic CZE
Quicksilver-2 GBR
Atlanta NOR
Canada-2 CAN
Luxembourg-2 LUX
Jeannette-18 FRA
Uruguay URU
Sylvia SWE
Central African Republic CAF
Honduras HON
Roy JPN
Three Star Too USA
Unique GBR
Sonja II NOR
Canada-3 CAN
Myojo JPN
Burevestnik URS
Russia-1 RUS
Scamasaxe-34 FRA
East Germany-1 GDR
Mohawk Indians-2 CAN
Ingegerd SWE
Djibouti DJI
Amateur Athletic Association AUS
Ali-Baba IX SUI
Austria AUT
New Zealand NZL
Vim III USA
Nortazo URU
Spain-2 ESP
Lucky Girl-1 FIN
Mignon-3 FRA
Kuling SWE
Tomahawk II CAN
Scotland-2 GBR
Japan-3 JPN
Saskia GBR
Greenoaks Dundee AUS
Fram III NOR
Greece-4 GRE
Namibia NAM
North Korea-1 PRK
Blue Red ARG
Russia-2 RUS
Xantippa FIN
Libya LBA
Roddklubben af 1912-1 SWE
Norway-1 NOR
Norman-1 RUS
Eissero VI FRA
Gabbiano AUS
West Germany-2 FRG
Gallant USA
Tajamar ESP
Ausonia ITA
Rampage ARG
Springbok RSA
Galopin-9 FRA
Gustel V GER
St. Louis Amateur Athletic Association USA
Timor Leste TLS
Guinea GUI
Gem II GBR
Guyoni FRA
Guatemala GUA
Boreas-2 NED
Iraq IRQ
Pan GER
Kiel DEN
France-3 FRA
Persey URS
Harmony NZL
Belgium-3 BEL
Czechoslovakia-1 TCH
Viking NOR
Zimbabwe ZIM
Ethnikos Gymnastikos Syllogos GRE
Indonesia-2 INA
Greece GRE
Concordia Turnverein, St Louis USA
Lithuania LTU
Ravel USA
Omilos Ereton Smyrnis GRE
Studenternes Roklub-2 NOR
Albania ALB
Lesotho LES
Norwegier Turnverein, Brooklyn USA
Cameroon CMR
Demi-Mondaine-17 FRA
Demi-Mondaine-15 FRA
Rowing Club Castillon-3 FRA
Thailand-1 THA
China-1 CHN
Korshun URS
Belgium-1 BEL
Socit Nautique de Bayonne-1 FRA
Notavel POR
Serbia and Montenegro SCG
Eleda NOR
Ecuador ECU
Winnipeg Shamrocks-1 CAN
Crabe II-4 FRA
Babe USA
San Marino SMR
June Climene SGP
Don Schufro DEN
Kathleen USA
Sea Dog-2 GBR
Yangon MYA
Ciocca II ITA
Latvia LAT
New York Athletic Club-1 USA
Haiti HAI
Damoiselle FRA
Scotland GBR
United States-12 USA
Kitty-1 SWE
Femur-1 FRA
Ludwigshafener Ruderverein GER
Peri RHO
Belarus BLR
Alain IV SUI
Racing Club de France COL
Ylliam VIII SUI
Peiraikos Syndesmos-2 GRE
Belize BIZ
Athens-2 GRE
United States/France USA
Bronia GER
Bohemia BOH
Aschenbrodel GER
Olympion GRE
Hungaria Evezos Egylet HUN
Favorite-17 FRA
Hungary-1 HUN
Maldives MDV
Hong Kong HKG
Plume-patte-32 FRA
Ali-Baba II SWE
Pakaria AUS
Poland-1 POL
Quand-Mme-2 FRA
England-1 GBR
Puerto Rico-2 PUR
Sabre GBR
Elisabeth X NOR
Pirouette-31 FRA
Liberia LBR
Aloha II SWE
Mongolia MGL
South Africa RSA
Hungary-3 HUN
Serbia-2 SRB
Portugal-1 POR
United States-13 USA
Patricia PHI
Angelita USA
United States/Great Britain GBR
Lancet GBR
Racing Club de France FRA
Bolivia BOL
Benin BEN
Falcon IV AUS
Galopin-20 FRA
Almaz URS
Gem VII BAH
Lemzos Thorichton "Spetsai"-4 GRE
Andorra AND
Nikh GRE
Dick-8 FRA
Cook Islands COK
K.S.S.S. 1912-2 SWE
GyoshuII CAM
Cincinnati Archers USA
Jupiter USA
Dow Jones JPN
Nina Claire-30 FRA
Leipzig FRA
South Africa-2 RSA
Enotria ITA
Central Turnverein, Chicago USA
Amulet-3 FRA
Mauritania MTN
North Yemen YAR
Quand-Mme-33 FRA
Germany/United States GER
Bagatelle Polo Club, Paris FRA
Malaya MAL
Great Britain/Germany GBR
Escapade BRA
Romania ROU
Favorite-1 FRA
Acturus ARG
Whitini Star FRA
Wannsee GER
Mamie-6 FRA
Myanmar MYA
SagaII CAN
Esterel-1 FRA
Gitana-21 FRA
Denmark/Sweden SWE
Lady C GBR
Ali-Baba VI SUI
Denmark DEN
Sass-2 SWE
Fada FRA
Twins VIII ITA
Miss Nippon V JPN
Hilarius USA
Nan-2 GBR
Australia AUS
Bingo USA
Mutafo GER
Mauritius-2 MRI
United Arab Emirates UAE
North Borneo NBO
Crocodile-13 FRA
Dinah V GER
Jo NOR
Nirwana GER
Espadarte POR
Estonia EST
Angerburg USA
Slaghoken SWE
Mali MLI
Cicely-1 GBR
Rush VII SWE
Mainz CHI
Gwendoline-2 FRA
Brynhild-2 GBR
Beaver GBR
Bonzo DEN
Compigne Polo Club FRA
Chinese Taipei TPE
Angola ANG
Snude DEN
Sweden-4 SWE
Esperia ITA
Unified Team-2 EUN
Cupidon Viking FRA
Nina Claire-2 FRA
Australia-3 AUS
Upton Park FC GBR
Mari SWE
May-Be 1960 AUT
Kenya KEN
Rambo JPN
Nephos I GRE
Fiji FIJ
Argo II CAN
Austria-2 AUT
Tornade-16 FRA
Elisabeth V NOR
Bim BAH
Hannover POR
Hungaria HUN
United States Virgin Islands ISV
DeRuyter NED
Peri II ZIM
United States/Great Britain USA
Liechtenstein LIE
Nicaragua NCA
London City Police-1 GBR
Unified Team-3 EUN
Turnverein Vorwrts, Chicago GER
Cuba CUB
Glisten CAN
Zut BEL
Czech Republic-1 CZE
Kingfisher MYA
Uragan URS
New York Athletic Club #2-4 USA
Dolfijn BEL
China-3 CHN
Thailand-2 THA
Ducky-4 FRA
France/Great Britain GBR
Italy-3 ITA
Serbia SRB
Heatherbell FIN
Spain ESP
Canada-1 CAN
Augsburg ITA
Milwaukee Turnverein, Milwaukee USA
Milwaukee Athletic Club-1 USA
Nigeria NGR
Libellule de Paris FRA
Gem IV BAH
Vanuatu VAN
Baby-9 FRA
Floresco SWE
Merope III ITA
Anitra DEN
United States-3 USA
Raili FIN
Malawi MAW
The Cloud IRL
Pigoule FRA
Emily GBR
Joy GBR
Slaghoken II SWE
Roehampton-1 GBR
Socit Nautique de la Basse Seine-2 FRA
Primorka YUG
Nauru NRU
Smyrna FRA
Suzon IV-39 FRA
Ral-Club Barcelona ESP
Cha-Cha III YUG
India IND
Bu III BRA
State VI CAN
Oleander XII BER
Colette-12 FRA
Switzerland SUI
Pupilles de Neptune de Lille #2-1 FRA
Verveine-41 FRA
Tom Kyle GER
Tan-Fe-Pah BEL
Socit Nautique de Bayonne FRA
Moldova MDA
Saudi Arabia KSA
Soviet Union-3 URS
Oxalis POR
Red Indian FRA
Pistoja/Firenze ITA
Amateur Athletic Association GBR
Yeoman BAH
St. Louis Southwest Turnverein #2-3 GER
Leander Club #2-2 GBR
Satchmo GER
Societ Nautique de la Marne-3 FRA
Pan II NOR
Brunei BRU
United States Virgin Islands-2 ISV
France FRA
Cercle de l'Aviron Roubaix-4 FRA
Crabe I-3 FRA
Cambodia CAM
Martha-1 FRA
Burkina Faso BUR
Gran Gesto CAN
Bohemia-1 BOH
Miss Nippon IV JAM
Singy-37 FRA
Mexico MEX
Erna Signe SWE
Mebi ITA
Glider USA
Christian Brothers' College-1 USA
Silja NOR
Antwerpia V BEL
Viktoriya URS
Greece-1 GRE
United States-4 USA
Union des Socits Franais de Sports Athletiques FRA
Bohemia/Great Britain GBR
Sheerio FIN
China-2 CHN
Tajikistan TJK
Niger NIG
Cuba-2 CUB
Samoa SAM
Netherlands-2 NED
Univ. of Brussels BEL
Frip IV FRA
Chicago Athletic Association USA
Germany GER
Hera-1 GBR
Bissbi SWE
Pupilles de Neptune de Lille-1 FRA
Thessalonki-1 GRE
Algeria ALG
Tornado SWE
Cupidon III ARG
Twinkle GBR
Tonga TGA
Shoveller RSA
Web III DEN
Bluebottle GBR
Missouri Athletic Club-3 USA
Gyp-23 FRA
Chamukina MEX
Llanoria USA
Pimm BRA
Costa Rica CRC
Barco Deloro NED
Wendehals GER
Ylliam VII SUI
Russia-3 RUS
United States-10 USA
Ardilla ARG
Boston Archers USA
Chuckles GBR
Argonaut Rowing Club CAN
St. Louis Southwest Turnverein #1-2 USA
Sri Lanka SRI
Belgium-2 BEL
Suzon IV-5 FRA
Denmark-4 DEN
Trintel II NED
Konstanz YUG
Singapore-2 SGP
Kullan SWE
Colombia COL
Rush IV USA
New Zealand-2 NZL
Bermuda BER
BLO Polo Club, Rugby FRA
Nirefs GRE
Kon-Tiki URS
K Division Metropolitan Police Team-3 GBR
Nigeria-1 NGR
Impala RSA
Slovenia SLO
Independent Rowing Club-3 USA
Sarcelle-35 FRA
Mascotte NED
Lotta IV SWE
Colette-10 FRA
Acipactli MEX
Suriname SUR
Club Nautique de Lyon-2 FRA
Magdalen College Boat Club-1 GBR
Druzhba URS
Minotaur USA
Mystery USA
Tuvalu TUV
Jill DEN
Fantlet-2 FRA
Sweden-2 SWE
Philadelphia Turngemeinde, Philadelphia AUT
Hornet AUS
Buraddoo AUS
Finland FIN
Cayman Islands CAY
Madagascar MAD
Aldebaran ITA
Sarcelle-3 FRA
Swift GBR
Rostock GER
Espuma del Mar VEN
Sidi Fekkar-36 FRA
Yugoslavia YUG
Cuba-1 CUB
Australia-2 AUS
Czechoslovakia TCH
A North American Team MEX
Ukraine-1 UKR
Starlight III GBR
Lemzos Thorichton "Psara"-3 GRE
Pierre et Jean-4 FRA
Italia ITA
Club Nautique de Franais-1 FRA
Latvia-1 LAT
Austria-1 AUT
Camille FRA
Western Rowing Club-3 USA
Souriceau-38 FRA
South St Louis Turnverein, St Louis USA
C.V.A.-14 FRA
Freia-19 FRA
Liverpool Police Team-2 GBR
Willem-Six NED
C.V.A.-7 FRA
Salamander GBR
Australia-1 AUS
Passaic Turnverein, Passaic USA
Socialer Turnverein, Detroit USA
New York Turnverein, New York USA
Djinn ARG
Foxhunters Hurlingham GBR
British Virgin Islands IVB
Chok DEN
Turquoise-1 FRA
Libellule de Paris-3 FRA
Lasha SWE
Olle GBR
Czechoslovakia-2 TCH
Mistral Hojris GBR
Mamie-4 FRA
Hong Kong-2 HKG
Nrnberg NED
Qatar QAT
Leander Club-2 GBR
Socit Nautique de Bayonne-2 FRA
Nykjbings paa Falster DEN
Jest NZL
Spirit III USA
Ethiopia ETH
Hakahana RSA
Atalanta Boat Club-2 USA
Norwegier Turnverein, Brooklyn NOR
Baccara SUI
Congo (Kinshasa) COD
Australasia ANZ
Ireland-3 GBR
Nokaut II URS
Tramontane FRA
Puerto Rico PUR
Indonesia-1 INA
Greece-2 GRE
Armenia ARM
Firebird II TTO
Individual Olympic Athletes IOA
United States USA
Syndi CAN
Kannibaltje FRA
Switzerland-2 SUI
Danaldo JPN
Italy-2 ITA
American Samoa ASA
Jamaica-2 JAM
Martha-27 FRA
Mouchette-2 GBR
Siames-Cat THA
Peru PER
Minerva Amsterdam NED
Salinero NED
Nora NOR
Germany/United States USA
Tunisia TUN
Bremen FIN
Snap DEN
Denmark/Sweden DEN
Grenada GRN
Tilly GER
Panhellenios Gymnastikos Syllogos-1 GRE
Neptun II URS
Afghanistan AFG
Royal Club Nautique de Gand GRE
Moorina AUS
Gam II FRA
France-4 FRA
Starita NED
Ballerina IV SUI
Souriceau-4 FRA
Mexico-2 MEX
L'Aile VI FRA
United States-6 USA
Tulilind URS
Yeoman VII GBR
Mizar ARG