-What class are you in? -I’m ____. A: in class 3, grade 7 B: in Class 3, Grade 7 C: class 3, grade 7 D: Class 3, Grade 7

设有关系SC（sno,cname,grade），各属性的含义分别为学号、课程名、成绩。若要将所有学生的“大学计算机基础”课程的成绩增加3分，能正确完成该操作的SQL语句是（）grade=grade+3WHEREcname='大学计算机基础'。

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)

把student表中id字段值小于3的记录，将这些记录的grade字段值都更新为100（） A: UPDATE FROM student SET grade=100 where id<;3 B: UPDATE student SET grade=100 where id<;3 C: UPDATE student SET grade=100 D: UPDATE INTO student SET grade=100 where id<;3

以下()语句可查询选修了三门以上成绩在80分以上课程的学生学号。 A: select snofromscwhere grade>80groupbysnohavingcount(cno)>3 B: select snofromscwhere grade>80groupbysnohavingcount(*)>3 C: select snofromscwhere grade>80 and  count(*)>3groupbysno D: elect snofromscwhere grade>80groupbysnohavingcount(sno)>3

I’m in Class 3,Grade 2,  _______________ ?

1.将选修C1课程的所有学生的成绩提高3%updatescsetgrade=grade()grade*0.03

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;

功能：计算平均成绩并统计90分以上人数。#include <;stdio.h>;main(){int n,m;float grade,average;average=0.0;/***********SPACE***********/n=m=【1】;while(1){【?】("%f",&amp;grade);if(grade<;0) break;n++;average+=grade;if(grade<;90)【3】;m++;}if(n) printf("%.2f%d\n",average/n,m);}