Tennis

Aus ProgrammingWiki

Spielwiese: Tennis

DROP TABLE IF EXISTS matches;

CREATE TABLE matches (
  id INTEGER NOT NULL, 
  tournier VARCHAR(35),
  gewinnsaetze INTEGER NOT NULL,
  jahr INTEGER NOT NULL,
  sieger VARCHAR(35),
  gegner VARCHAR(35),
  runde VARCHAR(35),
  dauer INTEGER,
  gespielte_saetze INTEGER,
  PRIMARY KEY (id)
);

INSERT INTO matches VALUES (1, 'Dubai Tennis', 2, 2012, 'Federer', 'Murray', 'Final', null, 2);
INSERT INTO matches VALUES (2, 'Dubai Tennis', 2, 2012, 'Federer', 'Del Potro', 'Halbfinal', null, 2);
INSERT INTO matches VALUES (3, 'Dubai Tennis', 2, 2012, 'Murray', 'Djokovic', 'Halbfinal', null, 2);

INSERT INTO matches VALUES (4, 'Australian Open', 3, 2012, 'Djokovic', 'Nadal', 'Final', 80+66+45+88+74, 2);
INSERT INTO matches VALUES (5, 'Australian Open', 3, 2012, 'Djokovic', 'Murray', 'Halbfinal', 47+65+88+25+65, 5);
INSERT INTO matches VALUES (6, 'Australian Open', 3, 2012, 'Nadal', 'Federer', 'Halbfinal', 56+44+67+55, 3);

INSERT INTO matches VALUES (7, 'US Open', 3, 2011, 'Djokovic', 'Nadal', 'Final', 53+71+84+42, 4);
INSERT INTO matches VALUES (8, 'US Open', 3, 2011, 'Djokovic', 'Federer', 'Halbfinal', 55+46+42+33+55, 5);
INSERT INTO matches VALUES (9, 'US Open', 3, 2011, 'Nadal', 'Murray', 'Halbfinal', 55+49+49+51, 4);

INSERT INTO matches VALUES (10, 'Wimbledon', 3, 2011, 'Djokovic', 'Nadal', 'Final', 41+33+30+44, 4);
INSERT INTO matches VALUES (11, 'Wimbledon', 3, 2011, 'Nadal', 'Murray', 'Halbfinal', 54+36+36+53, 4);
INSERT INTO matches VALUES (12, 'Wimbledon', 3, 2011, 'Djokovic', 'Tsonga', 'Halbfinal', 65+28+59+35, 4);

INSERT INTO matches VALUES (13, 'French Open', 3, 2011, 'Nadal', 'Federer', 'Final', 62+72+50+36, 4);
INSERT INTO matches VALUES (14, 'French Open', 3, 2011, 'Nadal', 'Murray', 'Halbfinal', 62+73+62, 3);
INSERT INTO matches VALUES (15, 'French Open', 3, 2011, 'Federer', 'Djokovic', 'Halbfinal', 70+45+37+67, 4);

INSERT INTO matches VALUES (16, 'Australian Open', 3, 2011, 'Djokovic', 'Murray', 'Final', null, 3);
INSERT INTO matches VALUES (17, 'Australian Open', 3, 2011, 'Djokovic', 'Federer', 'Halbfinal', null, 3);
INSERT INTO matches VALUES (18, 'Australian Open', 3, 2011, 'Murray', 'Ferrer', 'Halbfinal', null, 4);

Alle Einträge anzeigen

SELECT * FROM matches;

Tennis

Spielwiese: Tennis

Alle Einträge anzeigen

Suche