/*
//參賽隊（組別，球隊）

CREATE TABLE Team
(   group1  char(10),
    team1  nchar(20)  NOT NULL  UNIQUE,
  PRIMARY KEY (team1),
  CHECK(group1 BETWEEN 'A' AND 'H'))

  INSERT INTO Team
  VALUES ('A', '德國')

  INSERT INTO Team
  VALUES ('A', '哥斯達黎加')

  INSERT INTO Team
  VALUES ('A', '波蘭')

  INSERT INTO Team
  VALUES ('A', '厄瓜多爾')

  INSERT INTO Team
  VALUES ('B', '英格蘭')

  INSERT INTO Team
  VALUES ('B', '瑞典')

  INSERT INTO Team
  VALUES ('B', '巴拉圭')

  INSERT INTO Team
  VALUES ('B', '特立尼達和多巴哥')

  INSERT INTO Team
  VALUES ('C', '阿根廷')

  INSERT INTO Team
  VALUES ('C', '荷蘭')

  INSERT INTO Team
  VALUES ('C', '科特迪瓦')

  INSERT INTO Team
  VALUES ('C', '塞黑')

  INSERT INTO Team
  VALUES ('D', '墨西哥')

  INSERT INTO Team
  VALUES ('D', '葡萄牙')

  INSERT INTO Team
  VALUES ('D', '伊朗')

  INSERT INTO Team
  VALUES ('D', '安哥拉')

  INSERT INTO Team
  VALUES ('E', '意大利')

  INSERT INTO Team
  VALUES ('E', '捷克')

  INSERT INTO Team
  VALUES ('E', '加納')

  INSERT INTO Team
  VALUES ('E', '美國')

  INSERT INTO Team
  VALUES ('F', '巴西')

  INSERT INTO Team
  VALUES ('F', '克羅地亞')

  INSERT INTO Team
  VALUES ('F', '澳大利亞')

  INSERT INTO Team
  VALUES ('F', '日本')

  INSERT INTO Team
  VALUES ('G', '法國')

  INSERT INTO Team
  VALUES ('G', '瑞士')

  INSERT INTO Team
  VALUES ('G', '韓國')

  INSERT INTO Team
  VALUES ('G', '多哥')

  INSERT INTO Team
  VALUES ('H', '西班牙')

  INSERT INTO Team
  VALUES ('H', '烏克蘭')

  INSERT INTO Team
  VALUES ('H', '突尼斯')

  INSERT INTO Team
  VALUES ('H', '沙特')


SELECT COUNT(group1)
  FROM team
 WHERE group1='A'


SELECT *
  FROM Team
 ORDER BY group1
 
 

DELETE FROM Team


*/


/*
//參賽隊（組別，球隊，國旗）
ALTER TABLE Team
    ADD jack image



*/