Home | Admin | Impressum | Datenschutz
english deutsch
Zur Aufgabenübersicht

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 Joins → Aufgabe 3.3
Aufgabe Geben Sie die Namen aller Athleten sowie die Namen der Disziplinen aus, an denen sie teilgenommen haben und deren Gewicht weniger als 40 kg betrÃĪgt.
SQL Query
 
Ausgabe der Musterlösung — Datensätze : 33
athlete_name discipline_name
Svetlana Nikolayevna Baitova Gymnastics Women's Team All-Around
Oana Mihaela Ban Gymnastics Women's Team All-Around
Clara Basiana Caellas Synchronized Swimming Women's Team
Bi Wenjing Gymnastics Women's Uneven Bars
Loredana Boboc Gymnastics Women's Team All-Around
Nuria Cabanillas Provencio Rhythmic Gymnastics Women's Group
Laura Cutina Gymnastics Women's Team All-Around
Deng Linlin Gymnastics Women's Team All-Around
Deng Linlin Gymnastics Women's Balance Beam
Yelena Vladimirovna Dolgopolova Gymnastics Women's Team All-Around
Gabriela Drgoi Gymnastics Women's Team All-Around
Svetlana Nikolayevna Baitova Gymnastics Women's Team All-Around
Oana Mihaela Ban Gymnastics Women's Team All-Around
Clara Basiana Caellas Synchronized Swimming Women's Team
Bi Wenjing Gymnastics Women's Uneven Bars
Loredana Boboc Gymnastics Women's Team All-Around
Nuria Cabanillas Provencio Rhythmic Gymnastics Women's Group
Laura Cutina Gymnastics Women's Team All-Around
Deng Linlin Gymnastics Women's Team All-Around
Deng Linlin Gymnastics Women's Balance Beam
Yelena Vladimirovna Dolgopolova Gymnastics Women's Team All-Around
Gabriela Drgoi Gymnastics Women's Team All-Around
Svetlana Nikolayevna Baitova Gymnastics Women's Team All-Around
Oana Mihaela Ban Gymnastics Women's Team All-Around
Clara Basiana Caellas Synchronized Swimming Women's Team
Bi Wenjing Gymnastics Women's Uneven Bars
Loredana Boboc Gymnastics Women's Team All-Around
Nuria Cabanillas Provencio Rhythmic Gymnastics Women's Group
Laura Cutina Gymnastics Women's Team All-Around
Deng Linlin Gymnastics Women's Team All-Around
Deng Linlin Gymnastics Women's Balance Beam
Yelena Vladimirovna Dolgopolova Gymnastics Women's Team All-Around
Gabriela Drgoi Gymnastics Women's Team All-Around
by Christoph Gerstle, Florian Moritz, Bernhard Schiefer