sdept) values(‘95005’, ‘刘云’, ‘女’, 18, ‘CS’)
insert into course(cno, cname,credit,cpno) values(‘1’, ‘数据库...cname,credit,cpno) values(‘2’, ‘数学’, 6, null)
insert into course(cno, cname,credit,cpno) values(‘3’, ‘信息系统...chinesegrade as zong from studentgrad
select year(birth) as birthday from student where sdept=’CS’
由于建立表的时候生日的数据类型不是...*,sc.* from student,sc where (student.sno =* sc.sno) –(部分版本的不支持这句查询)
select student....sname,sage from student where sno in (select sno from sc where cno=(select cno from course where cname=’数据库