9)．查询学习1号课程的学生的最高分数、平均成绩。 10)．查询与“李洋”在同一个系学习的学生。
11). 查询出所有姓“李”的学生的学号、姓名和性别的信息。 12)．计算1*2*3*??*20（即20！）的和，并显示计算结果。
1)
create database [学生课程数据库] go 2)
create table course
([cno] char(6) primary key, [cname] char(40) , [cpno] char(40) , [CCredit] int , ) go 3)
create table Student
([Sno] char(6) primary key, [Sname] nchar(4) ,
[Ssex] nchar(1) default '男', [Sage] int ,
[Sdept] char(20) ) go 4)
create table SG
([Sno] char(6) references Student (Sno), [Cno] char(6) references course (Cno), [Grade] integer
CONSTRAINT [PK_SG] PRIMARY KEY CLUSTERED (
[Sno] ASC, [Cno] ASC ) ) go 5).
Alter table student Add Scome datetime
6).
Delete student
Where Sno=’05019’ 7).
Select * form student Where sdept=’管理系’ 8).
SELECT Sno, Grade FROM SG
WHERE Cno='3'
ORDER BY Grade DESC 9).
SELECT MAX(Grade), AVG(Grade) FROM SC
WHERE Cno='1' 10).
SELECT Sno, Sname, Sdept FROM Student WHERE Sdept IN
(SELECT Sdept FROM Student WHERE Sname='李洋') 11).
SELECT Sno, Sname, Ssex FROM Student
WHERE Sname like '李%' 12)
--计算1*2*3*??*20的值
DECLARE @I int,@j float,@cj char(10) SELECT @I=2,@j=1 WHILE @I<=20 BEGIN
SELECT @j =@j*@i SELECT @I=@I+1 END
SELECT @cj=convert(char(20),@j) print '1*2*3*??*20=' +@cj
