哈工大威海数据库试验.docVIP

4． select Student.sclass,Student.sno,sname,ssex,sage,sdept,cname,grade from Student LEFT JOIN SC ON (Student.sno=SC.sno AND Student.sclass=SC.sclass )LEFT JOIN Course 5． 6．select 2014-sage birth from Student where sname =刘晨; 7 select Student.sclass,Student.sno,sname,ssex,sage,sdept,cname,grade from Student LEFT JOIN SC ON (Student.sno=SC.sno AND Student.sclass=SC.sclass )LEFT JOIN Course where Student.sname like 刘% 8 select sname,ssex,grade from Student LEFT JOIN SC ON (Student.sno=SC.sno AND Student.sclass=SC.sclass )LEFT JOIN Course where o=1 9。 select cno,cname from Course where