/*

//小組賽記錄表（組別，球隊1，球隊2，場次，比賽時間，隊1進球數，隊2進球數）
//創建賽程安排及戰況記錄表

CREATE TABLE MatchRecord
(
    group1     nchar(10),
    team1      nchar(20) NOT NULL,
    team2      nchar(20) NOT NULL,
    number     int,
    fixture    datetime,
    goalsfor1  int  default 0,
    goalsfor2  int  default 0,
  PRIMARY KEY (team1,team2),
  FOREIGN KEY(team1) REFERENCES Team(team1),
  FOREIGN KEY(team2) REFERENCES Team(team1))

//小組賽第1輪
  INSERT INTO MatchRecord
  VALUES ('A', '德國','哥斯達黎加',1, '2006-6-10 0:0', 4, 2)

  INSERT INTO MatchRecord
  VALUES ('A', '波蘭', '厄瓜多爾', 2, '2006-6-10 3:00', 0, 2)

  INSERT INTO MatchRecord
  VALUES ('B', '英格蘭','巴拉圭', 3, '2006-6-10 21:00', 1, 0)

  INSERT INTO MatchRecord
  VALUES ('B', '特立尼達和多巴哥','瑞典', 4, '2006-6-11 0:00', 0, 0)

  INSERT INTO MatchRecord
  VALUES ('C', '阿根廷','科特迪瓦', 5, '2006-6-11 3:00', 2, 1)

  INSERT INTO MatchRecord
  VALUES ('C', '塞黑','荷蘭', 6, '2006-6-11 21:00', 0, 1)

  INSERT INTO MatchRecord
  VALUES ('D', '墨西哥','伊朗', 7, '2006-6-12 0:00', 3, 1)

  INSERT INTO MatchRecord
  VALUES ('D', '安哥拉','葡萄牙', 8, '2006-6-12 3:00', 0, 1)

  INSERT INTO MatchRecord
  VALUES ('E', '意大利','加納', 9, '2006-6-13 3:00', 2, 0)

  INSERT INTO MatchRecord
  VALUES ('E', '美國','捷克', 10, '2006-6-13 0:00', 0, 3)

  INSERT INTO MatchRecord
  VALUES ('F', '巴西','克羅地亞', 11, '2006-6-14 3:00', 1, 0)

  INSERT INTO MatchRecord
  VALUES ('F', '澳大利亞','日本', 12, '2006-6-12 21:00', 3, 1)

  INSERT INTO MatchRecord
  VALUES ('G', '法國','瑞士', 13, '2006-6-14 0:00', 0, 0)

  INSERT INTO MatchRecord
  VALUES ('G', '韓國','多哥', 14, '2006-6-13 21:00', 2, 1)

  INSERT INTO MatchRecord
  VALUES ('H', '西班牙','烏克蘭', 15, '2006-6-14 21:00', 4, 0)

  INSERT INTO MatchRecord
  VALUES ('H', '突尼斯','沙特', 16, '2006-6-15 0:00', 2, 2)

//小組賽第2輪
  INSERT INTO MatchRecord
  VALUES ('A', '德國','波蘭',17, '2006-6-15 3:0', 1, 0)

  INSERT INTO MatchRecord
  VALUES ('A', '厄瓜多爾', '哥斯達黎加', 18, '2006-6-15 21:00', 3, 0)

  INSERT INTO MatchRecord
  VALUES ('B', '英格蘭','特立尼達和多巴哥', 19, '2006-6-16 0:00', 2, 0)

  INSERT INTO MatchRecord
  VALUES ('B', '瑞典','巴拉圭', 20, '2006-6-16 3:00', 1, 0)

  INSERT INTO MatchRecord
  VALUES ('C', '阿根廷','塞黑', 21, '2006-6-16 21:00', 6, 0)

  INSERT INTO MatchRecord
  VALUES ('C', '荷蘭','科特迪瓦', 22, '2006-6-17 0:00', 2, 1)

  INSERT INTO MatchRecord
  VALUES ('D', '墨西哥','安哥拉', 23, '2006-6-17 3:00', 0, 0)

  INSERT INTO MatchRecord
  VALUES ('D', '葡萄牙','伊朗', 24, '2006-6-17 21:00', 2, 0)

  INSERT INTO MatchRecord
  VALUES ('E', '意大利','美國', 25, '2006-6-18 3:00', 1, 1)

  INSERT INTO MatchRecord
  VALUES ('E', '捷克','加納', 26, '2006-6-18 0:00', 0, 2)

  INSERT INTO MatchRecord
  VALUES ('F', '巴西','澳大利亞', 27, '2006-6-19 0:00', 2, 0)

  INSERT INTO MatchRecord
  VALUES ('F', '日本','克羅地亞', 28, '2006-6-18 21:00', 0, 0)

  INSERT INTO MatchRecord
  VALUES ('G', '法國','韓國', 29, '2006-6-19 3:00', 1, 1)

  INSERT INTO MatchRecord
  VALUES ('G', '多哥','瑞士', 30, '2006-6-19 21:00', 0, 2)

  INSERT INTO MatchRecord
  VALUES ('H', '西班牙','突尼斯', 31, '2006-6-20 3:00', 3, 1)

  INSERT INTO MatchRecord
  VALUES ('H', '沙特','烏克蘭', 32, '2006-6-20 0:00', 0, 4)

//小組賽第3輪
  INSERT INTO MatchRecord
  VALUES ('A', '厄瓜多爾','德國',33, '2006-6-20 22:0', 0, 3)

  INSERT INTO MatchRecord
  VALUES ('A', '哥斯達黎加', '波蘭', 34, '2006-6-20 22:00', 1, 2)

  INSERT INTO MatchRecord
  VALUES ('B', '瑞典','英格蘭', 35, '2006-6-21 3:00', 2, 2)

  INSERT INTO MatchRecord
  VALUES ('B', '巴拉圭','特立尼達和多巴哥', 36, '2006-6-21 3:00', 2, 0)

  INSERT INTO MatchRecord
  VALUES ('C', '荷蘭','阿根廷', 37, '2006-6-22 3:00', 0, 0)

  INSERT INTO MatchRecord
  VALUES ('C', '科特迪瓦','塞黑', 38, '2006-6-22 3:00', 3, 2)

  INSERT INTO MatchRecord
  VALUES ('D', '葡萄牙','墨西哥', 39, '2006-6-21 22:00', 2, 1)

  INSERT INTO MatchRecord
  VALUES ('D', '伊朗','安哥拉', 40, '2006-6-21 22:00', 1, 1)

  INSERT INTO MatchRecord
  VALUES ('E', '捷克','意大利', 41, '2006-6-22 22:00', 0, 2)

  INSERT INTO MatchRecord
  VALUES ('E', '加納','美國', 42, '2006-6-22 22:00', 2, 1)

  INSERT INTO MatchRecord
  VALUES ('F', '日本','巴西', 43, '2006-6-23 3:00', 1, 4)

  INSERT INTO MatchRecord
  VALUES ('F', '克羅地亞','澳大利亞', 44, '2006-6-23 3:00', 2, 2)

  INSERT INTO MatchRecord
  VALUES ('G', '多哥','法國', 45, '2006-6-24 3:00', 0, 2)

  INSERT INTO MatchRecord
  VALUES ('G', '瑞士','韓國', 46, '2006-6-24 3:00', 2, 0)

  INSERT INTO MatchRecord
  VALUES ('H', '沙特','西班牙', 47, '2006-6-23 22:00', 0, 1)

  INSERT INTO MatchRecord
  VALUES ('H', '烏克蘭','突尼斯', 48, '2006-6-23 22:00', 1, 0)


SELECT *
  FROM MatchRecord
 WHERE group1='A'
 ORDER BY number

DELETE FROM MatchRecord

*/