现有一个“学生—课程—成绩”数据库,数据库中包括三个表:答:① create table Student( Sno int not null PRIMARY KEY ,Sname string Unique, Ssex string ,Sage integer, Sdept string )② SELECT SG.Sno, SG.Grade FROM SG WHERE (((SG.Cno)=2))③ INSERT INTO sg(Sno,Cno,Cname,Grade)valves(“2012314”,”2”, “数据库管理”,90)④ UPDATE...
3.使用IF函数和逻辑函数,对Sheet1“学生成绩表”中的“结果1”和“结果...答:=IF(OR(AND(D3="男",E3<14),AND(D3="女",E3<16)),"合格","不合格")=IF(OR(AND(D3="男",G3>7.5),AND(D3="女",G3>5.5)),"合格","不合格")