在SQL SERVER中,使用教学（STC）数据库，创建函数st_grade。该函数以课程编号为参数，通过调用该函数显示指定课程的最高分、最低分及该课程的平均分。请完成下面代码填空。1）定义函数create st_grade(@cno char(10))returnsas return(select cno as 课程号, max(grade) as 最高分, min(grade) as 最低分, avg(grade) 平均分from scwhere cno=group by )2）调用函数，查询1号课的课程号、最高分、最低分及平均分。* from st_grade('1')

The most common division between primary and secondary education in the US is ___________.（ ） A: primary schools (Grade 1 to Grade 6) and middle schools (Grade 7 to Grade 12) B: elementary schools (Grade Kindergarten to Grade 8) and high schools (Grade 9 to Grade 12) C: elementary schools (Grade Kindergarten to Grade 3), middle schools (Grade 4 to Grade 6) and high schools (Grade 7 to Grade 12) D: grammar schools (Grade Kindergarten to Grade 6) and high schools (Grade 7 to Grade 12)

假定学生关系是ST(Sno，Sname,Sex,Age)，课程关系是CR(Cno,Cname,Credix),学生选课关系是SC(Sno，Cno，Grade).若要查找选修“数据库”课程的女学生的姓名，则将涉及的关系是（ ） A: ST，CR B: CR，SC C: ST，SC D: ST，CR，SC

Which grade were they in? A: Grade 8 B: Grade 9 C: Grade 10 D: Grade 11

【单选题】5. 假定student表中有字段grade,grade代表分数,依次统计grade字段的最大值,最小值,平均值的SQL语句是 A. SELECT max(grade),min(grade),average(grade) FROM student; B. SELECT max(grade),min(grade),avg(grade) FROM student; C. SELECT min(grade),average(grade),max(grade) FROM student; D. SELECT min(grade),avg(grade),max(grade) FROM student;

What grade is the woman in A: Grade one. B: Grade two. C: Grade three.

They are the students of ______. A: grade 7 B: Grade 7 C: 7th grade D: Grade 7th

查询统计选课表SC中成绩列Grade的最小值，可以用_______函数。 A: Min(Grade) B: Max(Grade) C: Avg(Grade) D: Sum(Grade)

查询统计选课表SC中成绩列Grade的平均值，可以用_______函数。 A: Sum(Grade) B: Avg(Grade) C: Min(Grade) D: Max(Grade)

下面代码的输出结果是()。 <?php $score=87; if($score>=90 && $score<=100){$grade="优秀";} if($score>=80){$grade="良好";} if($score>=70){$grade="一般";} if($score>=60){$grade="及格";} else{$grade="不及格";} echo $grade; ?>