values04计算方法302i
serti
tocoursevalues05数学分析322查看记录Selectfromcourse
13
f（4）、向成绩表中添加i
serti
toscorevalues05c12020188i
serti
toscorevalues05c12020261i
serti
toscorevalues05c12020372i
serti
toscorevalues05c12020551
i
serti
toscorevalues05c12010292
i
serti
toscorevalues05c12040180i
serti
toscorevalues05c12040478
i
serti
toscorevalues05c12050280i
serti
toscorevalues05c12050376i
serti
toscorevalues05c12050560
i
serti
toscorevalues05c12090467i
serti
toscorevalues05c12090248i
serti
toscorevalues05c12090354
14
fi
serti
toscorevalues05c12110585
i
serti
toscorevalues05c12140263i
serti
toscorevalues05c12140564
i
serti
toscorevalues05c12120241
i
serti
toscorevalues05c12130390i
serti
toscorevalues05c12130189
i
serti
toscorevalues05c12070176i
serti
toscorevalues05c12070272i
serti
toscorevalues05c12070456
i
serti
toscorevalues05c12080188i
serti
toscorevalues05c12080285i
serti
toscorevalues05c12080371i
serti
toscorevalues05c12080483i
serti
toscorevalues05c12080585查看记录Selectfromscore
15
f3一些查询语句1、查询性别为男的学号，姓名，班级，课程号和成绩的学生selectstude
ts
ostude
ts
amestude
tclassscorec
oscoredegreefromstude
tscorewherestude
ts
oscores
oa
dssex男
16
f（2）、查询成绩在60到80之间的所有列selectfromscorewheredegreebetwee
60a
d80
（3）查询score表中至少有5名学生选修的并以0开头的课程的平、均分selectavgdegreeas