欧阳和小白的技术博客

山东大学数据库实验答案

山东大学数据库实验五答案

1.create view test6_01 as select sid,name,dname from pub.STUDENT where age<20 and dname='物理学院'order by sidselect * from test6_012.create view test6_02(sid,name,sum_score) as (select pub.student.si

1.create table test7_01 (First_name varchar(4),frequency numeric(4))create table test71 as(select substr(name,2,2) as first_namefrom pub.STUDENT)create table test72 as(select first_name,count(f

1.create table test81 as(select pub.STUDENT_course.SID,pub.STUDENT.DNAME,max(score) as scorefrom pub.STUDENT,pub.STUDENT_COURSE,pub.COURSEwhere pub.STUDENT_COURSE.SID=pub.student.sidand pub.STUDEN