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) → Inner Joins → Aufgabe 4.4
Aufgabe Finde alle Athleten, die eine Medaille gewonnen haben, und zeige die Disziplin, das Team und den Medaillentyp.
SQL Query
 
Ausgabe der Musterlösung — Datensätze : 234
athlete_name discipline_name team_name medal
Ademir Roque Kaefer Football Men's Football Beaver Silver
Ademir Roque Kaefer Football Men's Football Beaver Silver
Ademir Roque Kaefer Football Men's Football Beaver Silver
Ademir Roque Kaefer Football Men's Football Beaver Silver
Ademir Roque Kaefer Football Men's Football Beaver Silver
Ademir Roque Kaefer Football Men's Football Beaver Silver
Adriana Aparecida dos Santos Basketball Women's Basketball Pan II Silver
Adriana Aparecida dos Santos Basketball Women's Basketball Pan II Silver
Adriana Aparecida dos Santos Basketball Women's Basketball Pan II Silver
Attila Adrovicz Canoeing Men's Kayak Fours, 1,000 metres Crabe I-3 Silver
Attila Adrovicz Canoeing Men's Kayak Fours, 1,000 metres Crabe I-3 Silver
Attila Adrovicz Canoeing Men's Kayak Fours, 1,000 metres Crabe I-3 Silver
Ayodele "Dele" Adeleye Football Men's Football Espadarte Silver
Ayodele "Dele" Adeleye Football Men's Football Espadarte Silver
Ayodele "Dele" Adeleye Football Men's Football Espadarte Silver
Benjamin Alexandro "Ben" Agosto Figure Skating Mixed Ice Dancing Indonesia-1 Silver
Benjamin Alexandro "Ben" Agosto Figure Skating Mixed Ice Dancing Indonesia-1 Silver
Benjamin Alexandro "Ben" Agosto Figure Skating Mixed Ice Dancing Indonesia-1 Silver
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Silver
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Silver
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Silver
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Silver
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Silver
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Silver
Clarisse Agbegnenou Judo Women's Half-Middleweight Yugoslavia Silver
Clarisse Agbegnenou Judo Women's Half-Middleweight Yugoslavia Silver
Clarisse Agbegnenou Judo Women's Half-Middleweight Yugoslavia Silver
Daniel Adler Sailing Mixed Three Person Keelboat Serbia Silver
Daniel Adler Sailing Mixed Three Person Keelboat Serbia Silver
Daniel Adler Sailing Mixed Three Person Keelboat Serbia Silver
Egon Adler Cycling Men's 100 kilometres Team Time Trial Heatherbell Silver
Egon Adler Cycling Men's 100 kilometres Team Time Trial Heatherbell Silver
Egon Adler Cycling Men's 100 kilometres Team Time Trial Heatherbell Silver
Erik William Adlerz Diving Men's Platform Baby-9 Silver
Erik William Adlerz Diving Men's Platform Baby-9 Silver
Erik William Adlerz Diving Men's Platform Baby-9 Silver
Klaus Aeffke Rowing Men's Coxed Eights China-2 Silver
Klaus Aeffke Rowing Men's Coxed Eights China-2 Silver
Klaus Aeffke Rowing Men's Coxed Eights China-2 Silver
Kseniya Dmitriyevna Afanasyeva Gymnastics Women's Team All-Around Llanoria Silver
Kseniya Dmitriyevna Afanasyeva Gymnastics Women's Team All-Around Llanoria Silver
Kseniya Dmitriyevna Afanasyeva Gymnastics Women's Team All-Around Llanoria Silver
Luca Agamennoni Rowing Men's Quadruple Sculls Mystery Silver
Luca Agamennoni Rowing Men's Quadruple Sculls Mystery Silver
Luca Agamennoni Rowing Men's Quadruple Sculls Mystery Silver
Muhammad Afzal Manna Hockey Men's Hockey Sarcelle-35 Silver
Muhammad Afzal Manna Hockey Men's Hockey Sarcelle-35 Silver
Muhammad Afzal Manna Hockey Men's Hockey Sarcelle-35 Silver
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Silver
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Silver
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Silver
Olabisi "Bisi" Afolabi Athletics Women's 4 x 400 metres Relay Trintel II Silver
Olabisi "Bisi" Afolabi Athletics Women's 4 x 400 metres Relay Trintel II Silver
Olabisi "Bisi" Afolabi Athletics Women's 4 x 400 metres Relay Trintel II Silver
Olapade Charles Adeniken Athletics Men's 4 x 100 metres Relay Snude Silver
Olapade Charles Adeniken Athletics Men's 4 x 100 metres Relay Snude Silver
Olapade Charles Adeniken Athletics Men's 4 x 100 metres Relay Snude Silver
Olubayo Adefemi Football Men's Football Hilarius Silver
Olubayo Adefemi Football Men's Football Hilarius Silver
Olubayo Adefemi Football Men's Football Hilarius Silver
Richard "Richy" Adjei Bobsleigh Men's Two Czech Republic-1 Silver
Richard "Richy" Adjei Bobsleigh Men's Two Czech Republic-1 Silver
Richard "Richy" Adjei Bobsleigh Men's Two Czech Republic-1 Silver
Robert Edward "Bob" Adlard Hockey Men's Hockey France/Great Britain Silver
Robert Edward "Bob" Adlard Hockey Men's Hockey France/Great Britain Silver
Robert Edward "Bob" Adlard Hockey Men's Hockey France/Great Britain Silver
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Silver
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Silver
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Silver
Yannick Agnel Swimming Men's 4 x 200 metres Freestyle Relay Socit Nautique de Bayonne-2 Silver
Yannick Agnel Swimming Men's 4 x 200 metres Freestyle Relay Socit Nautique de Bayonne-2 Silver
Yannick Agnel Swimming Men's 4 x 200 metres Freestyle Relay Socit Nautique de Bayonne-2 Silver
Adenzia Aparecida Ferreira da Silva Volleyball Women's Volleyball Esperia Gold
Adenzia Aparecida Ferreira da Silva Volleyball Women's Volleyball Esperia Gold
Adenzia Aparecida Ferreira da Silva Volleyball Women's Volleyball Esperia Gold
Andre Kirk Agassi Tennis Men's Singles Finland Gold
Andre Kirk Agassi Tennis Men's Singles Finland Gold
Andre Kirk Agassi Tennis Men's Singles Finland Gold
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Gold
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Gold
Carlo Agostoni Faini Fencing Men's epee, Team Individual Olympic Athletes Gold
Charles "Chuck" Adkins Boxing Men's Light-Welterweight Thailand-2 Gold
Charles "Chuck" Adkins Boxing Men's Light-Welterweight Thailand-2 Gold
Charles "Chuck" Adkins Boxing Men's Light-Welterweight Thailand-2 Gold
Derrick Ralph Adkins Athletics Men's 400 metres Hurdles Ducky-4 Gold
Derrick Ralph Adkins Athletics Men's 400 metres Hurdles Ducky-4 Gold
Derrick Ralph Adkins Athletics Men's 400 metres Hurdles Ducky-4 Gold
Erik William Adlerz Diving Men's Platform Baby-9 Gold
Erik William Adlerz Diving Men's Platform Baby-9 Gold
Erik William Adlerz Diving Men's Plain High Baby-9 Gold
Erik William Adlerz Diving Men's Platform Baby-9 Gold
Erik William Adlerz Diving Men's Plain High Baby-9 Gold
Erik William Adlerz Diving Men's Plain High Baby-9 Gold
Estella "Stella" Agsteribbe (-Blits) Gymnastics Women's Team All-Around Bremen Gold
Estella "Stella" Agsteribbe (-Blits) Gymnastics Women's Team All-Around Bremen Gold
Estella "Stella" Agsteribbe (-Blits) Gymnastics Women's Team All-Around Bremen Gold
Franck Adisson Canoeing Men's Canadian Doubles, Slalom Cuba Gold
Franck Adisson Canoeing Men's Canadian Doubles, Slalom Cuba Gold
Franck Adisson Canoeing Men's Canadian Doubles, Slalom Cuba Gold
Ioannis Agrimis Rowing Men's 17-Man Naval Rowing Boats Nora Gold
Ioannis Agrimis Rowing Men's 17-Man Naval Rowing Boats Nora Gold
Ioannis Agrimis Rowing Men's 17-Man Naval Rowing Boats Nora Gold
Judit goston-Mendelnyi Fencing Women's Foil, Team Firebird II Gold
Judit goston-Mendelnyi Fencing Women's Foil, Team Firebird II Gold
Judit goston-Mendelnyi Fencing Women's Foil, Team Firebird II Gold
Lavinia Agache (-Carney) Gymnastics Women's Team All-Around Suriname Gold
Lavinia Agache (-Carney) Gymnastics Women's Team All-Around Suriname Gold
Lavinia Agache (-Carney) Gymnastics Women's Team All-Around Suriname Gold
Marilyn Agliotti Hockey Women's Hockey Hong Kong-2 Gold
Marilyn Agliotti Hockey Women's Hockey Hong Kong-2 Gold
Marilyn Agliotti Hockey Women's Hockey Hong Kong-2 Gold
Marilyn Agliotti Hockey Women's Hockey Hong Kong-2 Gold
Marilyn Agliotti Hockey Women's Hockey Hong Kong-2 Gold
Marilyn Agliotti Hockey Women's Hockey Hong Kong-2 Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Meghan Christina Agosta (-Marciano) Ice Hockey Women's Ice Hockey Baccara Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Medley Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 100 metres Freestyle Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Medley Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Medley Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Medley Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 100 metres Freestyle Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 100 metres Freestyle Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Medley Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Freestyle Relay Leander Club #2-2 Gold
Nathan Ghar-Jun Adrian Swimming Men's 4 x 100 metres Medley Relay Leander Club #2-2 Gold
Nils August Domingo Adlercreutz Equestrianism Men's Three-Day Event, Team Libellule de Paris Gold
Nils August Domingo Adlercreutz Equestrianism Men's Three-Day Event, Team Libellule de Paris Gold
Nils August Domingo Adlercreutz Equestrianism Men's Three-Day Event, Team Libellule de Paris Gold
Rebecca "Becky" Adlington Swimming Women's 400 metres Freestyle Anitra Gold
Rebecca "Becky" Adlington Swimming Women's 800 metres Freestyle Anitra Gold
Rebecca "Becky" Adlington Swimming Women's 400 metres Freestyle Anitra Gold
Rebecca "Becky" Adlington Swimming Women's 800 metres Freestyle Anitra Gold
Rebecca "Becky" Adlington Swimming Women's 800 metres Freestyle Anitra Gold
Rebecca "Becky" Adlington Swimming Women's 400 metres Freestyle Anitra Gold
Sergio Leonel Agero del Castillo Football Men's Football Moorina Gold
Sergio Leonel Agero del Castillo Football Men's Football Moorina Gold
Sergio Leonel Agero del Castillo Football Men's Football Moorina Gold
Taismary "Tai" Agero Leiva (-Botteghi) Volleyball Women's Volleyball Gam II Gold
Taismary "Tai" Agero Leiva (-Botteghi) Volleyball Women's Volleyball Gam II Gold
Taismary "Tai" Agero Leiva (-Botteghi) Volleyball Women's Volleyball Gam II Gold
Yannick Agnel Swimming Men's 200 metres Freestyle Socit Nautique de Bayonne-2 Gold
Yannick Agnel Swimming Men's 4 x 100 metres Freestyle Relay Socit Nautique de Bayonne-2 Gold
Yannick Agnel Swimming Men's 4 x 100 metres Freestyle Relay Socit Nautique de Bayonne-2 Gold
Yannick Agnel Swimming Men's 200 metres Freestyle Socit Nautique de Bayonne-2 Gold
Yannick Agnel Swimming Men's 4 x 100 metres Freestyle Relay Socit Nautique de Bayonne-2 Gold
Yannick Agnel Swimming Men's 200 metres Freestyle Socit Nautique de Bayonne-2 Gold
Adriana "Adrianinha" Moiss Pinto Basketball Women's Basketball France Bronze
Adriana "Adrianinha" Moiss Pinto Basketball Women's Basketball France Bronze
Adriana "Adrianinha" Moiss Pinto Basketball Women's Basketball France Bronze
Adriana Aparecida dos Santos Basketball Women's Basketball Pan II Bronze
Adriana Aparecida dos Santos Basketball Women's Basketball Pan II Bronze
Adriana Aparecida dos Santos Basketball Women's Basketball Pan II Bronze
Anna Mrtha Vilhelmina Adlerstrhle (von Oelreich-) Tennis Women's Singles, Covered Courts Gem IV Bronze
Anna Mrtha Vilhelmina Adlerstrhle (von Oelreich-) Tennis Women's Singles, Covered Courts Gem IV Bronze
Anna Mrtha Vilhelmina Adlerstrhle (von Oelreich-) Tennis Women's Singles, Covered Courts Gem IV Bronze
Carlo Agostoni Faini Fencing Men's epee, Individual Individual Olympic Athletes Bronze
Carlo Agostoni Faini Fencing Men's epee, Individual Individual Olympic Athletes Bronze
Carlo Agostoni Faini Fencing Men's epee, Individual Individual Olympic Athletes Bronze
Cecil Sebastian Afrika Rugby Sevens Men's Rugby Sevens Bermuda Bronze
Cecil Sebastian Afrika Rugby Sevens Men's Rugby Sevens Bermuda Bronze
Cecil Sebastian Afrika Rugby Sevens Men's Rugby Sevens Bermuda Bronze
Dainius Adomaitis Basketball Men's Basketball Oleander XII Bronze
Dainius Adomaitis Basketball Men's Basketball Oleander XII Bronze
Dainius Adomaitis Basketball Men's Basketball Oleander XII Bronze
Erik Alfred gren Boxing Men's Lightweight Jamaica-2 Bronze
Erik Alfred gren Boxing Men's Lightweight Jamaica-2 Bronze
Erik Alfred gren Boxing Men's Lightweight Jamaica-2 Bronze
Eugene Addor Shooting Men's Military Rifle, 300 metres and 600 metres, Prone, Team Myanmar Bronze
Eugene Addor Shooting Men's Military Rifle, 300 metres and 600 metres, Prone, Team Myanmar Bronze
Eugene Addor Shooting Men's Military Rifle, 300 metres and 600 metres, Prone, Team Myanmar Bronze
Felicia Afrsiloaie (-Jitianu) Rowing Women's Coxed Quadruple Sculls New Zealand-2 Bronze
Felicia Afrsiloaie (-Jitianu) Rowing Women's Coxed Quadruple Sculls New Zealand-2 Bronze
Felicia Afrsiloaie (-Jitianu) Rowing Women's Coxed Quadruple Sculls New Zealand-2 Bronze
Franck Adisson Canoeing Men's Canadian Doubles, Slalom Cuba Bronze
Franck Adisson Canoeing Men's Canadian Doubles, Slalom Cuba Bronze
Franck Adisson Canoeing Men's Canadian Doubles, Slalom Cuba Bronze
Gregor Nils Henric Adlercreutz Equestrianism Men's Dressage, Team Nigeria Bronze
Gregor Nils Henric Adlercreutz Equestrianism Men's Dressage, Team Nigeria Bronze
Gregor Nils Henric Adlercreutz Equestrianism Men's Dressage, Team Nigeria Bronze
Henrik Agersborg Sailing Mixed 6 metres Camille Bronze
Henrik Agersborg Sailing Mixed 6 metres Camille Bronze
Henrik Agersborg Sailing Mixed 6 metres Camille Bronze
Lavinia Agache (-Carney) Gymnastics Women's Horse Vault Suriname Bronze
Lavinia Agache (-Carney) Gymnastics Women's Horse Vault Suriname Bronze
Lavinia Agache (-Carney) Gymnastics Women's Horse Vault Suriname Bronze
Luca Agamennoni Rowing Men's Coxless Fours Mystery Bronze
Luca Agamennoni Rowing Men's Coxless Fours Mystery Bronze
Luca Agamennoni Rowing Men's Coxless Fours Mystery Bronze
Maksim Sergeyevich Afinogenov Ice Hockey Men's Ice Hockey Belgium-2 Bronze
Maksim Sergeyevich Afinogenov Ice Hockey Men's Ice Hockey Belgium-2 Bronze
Maksim Sergeyevich Afinogenov Ice Hockey Men's Ice Hockey Belgium-2 Bronze
Margarete "Grete" Adler Swimming Women's 4 x 100 metres Freestyle Relay Spain Bronze
Margarete "Grete" Adler Swimming Women's 4 x 100 metres Freestyle Relay Spain Bronze
Margarete "Grete" Adler Swimming Women's 4 x 100 metres Freestyle Relay Spain Bronze
Nathan Ghar-Jun Adrian Swimming Men's 50 metres Freestyle Leander Club #2-2 Bronze
Nathan Ghar-Jun Adrian Swimming Men's 100 metres Freestyle Leander Club #2-2 Bronze
Nathan Ghar-Jun Adrian Swimming Men's 50 metres Freestyle Leander Club #2-2 Bronze
Nathan Ghar-Jun Adrian Swimming Men's 50 metres Freestyle Leander Club #2-2 Bronze
Nathan Ghar-Jun Adrian Swimming Men's 100 metres Freestyle Leander Club #2-2 Bronze
Nathan Ghar-Jun Adrian Swimming Men's 100 metres Freestyle Leander Club #2-2 Bronze
Rebecca "Becky" Adlington Swimming Women's 800 metres Freestyle Anitra Bronze
Rebecca "Becky" Adlington Swimming Women's 400 metres Freestyle Anitra Bronze
Rebecca "Becky" Adlington Swimming Women's 400 metres Freestyle Anitra Bronze
Rebecca "Becky" Adlington Swimming Women's 400 metres Freestyle Anitra Bronze
Rebecca "Becky" Adlington Swimming Women's 800 metres Freestyle Anitra Bronze
Rebecca "Becky" Adlington Swimming Women's 800 metres Freestyle Anitra Bronze
Sammi Adjei Football Men's Football Kingfisher Bronze
Sammi Adjei Football Men's Football Kingfisher Bronze
Sammi Adjei Football Men's Football Kingfisher Bronze
Simon Addo Football Men's Football Wannsee Bronze
Simon Addo Football Men's Football Wannsee Bronze
Simon Addo Football Men's Football Wannsee Bronze
Timothy Ernest Victor Kwizera "Tim" Agaba Rugby Sevens Men's Rugby Sevens Colette-10 Bronze
Timothy Ernest Victor Kwizera "Tim" Agaba Rugby Sevens Men's Rugby Sevens Colette-10 Bronze
Timothy Ernest Victor Kwizera "Tim" Agaba Rugby Sevens Men's Rugby Sevens Colette-10 Bronze
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Bronze
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Bronze
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Bronze
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Bronze
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Bronze
Viktor Ivanovich Ageyev Water Polo Men's Water Polo South St Louis Turnverein, St Louis Bronze