SQL练习题

1. 运动会比赛信息的数据库，有如下三个表： 运动会ATHLETE(运动源编号Ano,性能Aname,性别Asex,所属系名Adep),
项目ITEM(项目编号Ino,名称lname，比赛地点llocation)，
成绩Score(运动员编号Ano，项目编号lno,积分Score)。

--A
Select Adep,SUM(Score) From ATHLETE,Score
Where ATHLETE.Ano = Score.Ano GROUP BY Adep
HAVING SUM(Score) >= SOME
(Select SUM(Score) From ATHLETE,Score 
Where WHERE ATHLETE.Ano = SCORE.Ano GROUP BY Adep
)

--B
Select Adep,SUM(Score) From ATHLETE,Score
Where ATHLETE.Ano = Score.Ano GROUP BY</