sql练习题

–1.修改student表名为student_demo
alter table student rename to student_demo;
select * from student_demo;
–2.通过student_demo新建一张表结构一致，包含数据的表student_create
create table student_create as select * from student_demo;
select * from student_create;
–3.删除student_create所有数据
delete from student_create;
select * from student_create;
–4.删除student_create这张表
drop table student_create;
select * from student_create;
–5.修改student_demo表sname字段类型为NVARCHAR2(20);
alter table student_demo modify (sname varchar2(20));
–6.通过脚本在student_demo表中添加sfzhm字段 VARCHAR2(18);
alter table student_demo add(sfzhm varchar2(18));
–7.新增加一条学生数据：姓名 ：刘玉 年龄22 性别：男
insert into student_demo (sno,sname,sage,ssex) values(‘s011’,‘刘玉’,22,‘男’);
select * from student_demo;
–8.更新学号s007学生的身份证号为340721188505153922
update student_demo set sfzhm=340721188505153922 where sno=‘s007’;
select * from student_demo;
–9、查询姓“张”的学生名单
select * from student_demo where sname like ‘张%’;
–10、查询姓“刘”的老师的个数
select * from teacher;
select count(*) from teacher where tname like ‘刘%’;
–11、查询每门课程被选修的学生数
select * from sc;
select cno,count(cno) from sc group by cno;
–12、查询所有同学的学号、姓名、选课数、总成绩
select s.sno 学号,
s.sname 姓名,