team.sql

世界杯足球赛统计

/*
//参赛队（组别，球队）

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



*/