SQL基本练习题(最新整理).docxVIP

第一阶段题目：以下练习题是根据初始化到数据库中的表执行的，请务必先执行如下建表语句。create table s1_student( sno varchar2(10) primary key, sname varchar2(30), sbirthday varchar2(30), ssex varchar2(10),sclass varchar2(10) ); create table s1_teacher( tno varchar2(10) primary key, tname varchar2(30),tsex varchar2(10),tbirthday varchar2(30),prof varchar2(30),depart varchar2(30) ); create table s1_course( cno varchar2(10), cname varchar2(30), tno varchar2(10) ); create table s1_score( sno varchar2(10), cno varchar2(10), degree number );create table s1_grade( low number, upp number, rank varchar2(2) );/*******初始化学生表s1_student******/ insert into s1_student values (108, 曾华, 1997/9/1, 男, 95033);insert into s1_student values (105, 匡明, 1995/10/2, 男, 95031);insert into s1_student values (107, 王丽, 1996/1/23, 女, 95033);insert into s1_student values (101, 李军, 1996/2/20, 男, 95033);insert into s1_student values (109, 王芳, 1995/2/10, 女, 95031);insert into s1_student values (103, 陆君, 1994/6/3, 男, 95031);commit; /*******初始化教师表s1_teacher*******/ insert into s1_teacher values (804, 李诚,男,1979-12-2,副教授,计算机系); insert into s1_teacher values (856, 张旭,男,1985-3-12,讲师,电子工程系); insert into s1_teacher values (825, 王萍,女,1989-5-2,助教,计算机系); insert into s1_teacher values (831, 刘冰,女,1988-8-2,助教,电子工程系); commit; /*******初始化课程表s1_course********/ insert into s1_course values (3-105, 计算机导论, 825);insert into s1_course values (3-245, 操作系统, 804);insert into s1_course values (6-166, 数据电路, 856);insert into s1_course values (9-888, 高等数学, 800);commit; /********初始化成绩表s1_score*********/insert into s1_score values (103, 3-245, 86);insert into s1_score values (105, 3-245, 75);insert into s1_score values (109, 3-245, 68);insert into s1_score values (103, 3-105, 92);insert into s1_score values (105, 3-105, 88);insert into s1_score values (109, 3-105, 76);insert into s1_score values (101, 3-105, 64);insert into s1_score values (107, 3-105, 91);insert into s1_score values (108, 3-105, 78);insert into s1_score values (101, 6-166, 85);insert into s1_score values