SQL语句 统计各个学生的不及格科目数量及不及格率 ,2条语句答:--创建表 create table student (姓名 nvarchar(20),数学 float,语文 float,英语 float,体育 float,物理 float,化学 float )go --插入语句 insert into student values('枫',50,60,70,50,60,40)insert into student values('巅',60,80,50,58,80,90)go --查询 select * from student go ...
用sql创建一个学生信息视图V_STU。(含Sno,Sname,Sage,Sdept)。_百度知 ...答:create view v_stu as select sno,sname,sage,sdept from student 第一题:create view v_stua as select sno,sname,sage,sdept from v_stu where sage>18;第二题:create view stu_a as select sno,sname,cname,grade from v_stu where classno="200608";第三题:create view c_stu as s...