用sql语句创建课程表例题

❶ 用T-SQL语句完成下列题目。在名称为“教学库”的数据库中有三个表学生表，课程表和成绩表它们的定义如下

1
select b.课程名,isnull(count(*),0)
from 课程表 a,成绩表 b on a.课程号回=b.课程号
group by b.课程名答
2
select a.姓名,b.课程名,c.成绩 from 学生表 a,课程表 b,成绩表 c
where a.学号=c.学号 and b.课程号=c.课程号
and a.性别='女' and b.课程名='计算机基础'
3
这个，你自己添加数据就好啦
4
update 课程表 set 学分=学分+1 where 课程号='001'

5
select * from 课程表 where 课程名 like '计算机%'

❷ 用SQL语句实现：学生表、课程表、选课表三张表中的问题：

1）select 课程表.课程名,count(学号)From 课程表 inner join 选课表On 课程表.课程号=选课表.课程号Group by 学号 2）Create View AllChoosenAs select DISTINCT(课程表.课程名)
From 课程表 inner join 选课表 On 课程表.课程号=选课表.课程号 3）Select 学生表.姓名 From 学生表 Where 学号 Not In (Select 学号 From 选课表) 4）select 学生表.学号,学生表.姓名,课程表.课程名,课程学分 From 学生表 Left Join 选课表 On 学生表.学号=选课表.学号 Inner Join 课程表 On 课程表.课程号=选课表.课程号 5）select 学生表.姓名 From 学生表 where 学号 In (Select 学号 From 选课表 Group by 学号 Having(count(课程号)>2) 6）select 学生表.姓名 From 学生表 where 学号 In (Select 学号 From 选课表 Group by 学号 Having(count(课程号)=select count(*) From 课程表) 7）delete from 选课表 where 学号=(select top 1 学号 From 学生表 where 姓名='张三')

❸ 用SQL语句实现：学生表、课程表、选课表三张表中的问题：

用子查询
select 姓名
from 学生,选课,课程
where 学生.学号=选课.学号 and 选课.课程号=课程.课程号 and 课程.课程名='数据库'
and 学生.学号 in
(select 学生.学号
from 学生,选课,课程
where 学生.学号=选课.学号 and 选课.课程号=课程.课程号 and 课程.课程名='操作系统';
}

❹ SQL命令 “学生”数据库中有 “学生表”、“课程表”和 “成绩表”。 “学生表”中包含学号、姓名

1、首先在电脑上打开数据库软件。然后附加有学生表和成绩表的数据库。

❺ 建课程表的sql语句

CREATE course
(
co_id VARCHAR(5) PRIMARY KEY,
co_name VARCHAR(3) NOT NULL,
co_desc VARCHAR(60)
)

SELECT
a.sc_name,
b.co_name,
a.sc_score
FROM score a, course b
WHERE a.sc_courseid = b.co_id
AND substr(a.sc_number,1,2) = '98'
AND a.sc_sex = '0'
AND a.sc_score < 60;

仅供参考

❻ 如果课程表c是使用以下sql语句创建的：create table c(cno c(2) not null ,cname c(20) ,cfen() n(1)):下

正确答案是D？

❼ 在数据库teacher_class下，写出创建教师表、课程表、授课表的SQL语句，各表结构如下所示：

（1）alter table tc add ‘修课类别’ nchar（1）；
（2）alter table tc modify ‘修课类别’ nchar（2）;
（3）alter table tc drop column ‘修课类别’；

❽ 已知三个关系模式(学生表,课程表,成绩表)用SQL语句实现以下内容

CREATE TABLE 选课表

(学号 CHAR(8) REFERENCES 学生表(学号),
课程编号 CHAR(6) REFERENCES 课程表(课程编号),
成绩 smallint)
GO
INSERT INTO 学生表 VALUES('20100101','李丹','女','1993-6-6','管理系')

GO
SELECT 学号,姓名,所在系

FROM 学生表
GO
SELECT 学生表.学号,姓名
FROM 学生表 JOIN 选课表 ON 学生表.学号=选课表.学号
WHERE 课程编号='A01-02'
GO
SELECT *
FROM 学生表
WHERE 姓名 LIKE '[赵李张]%'
GO
SELECT 课程名称,COUNT(*) AS 选修总人数

INTO 修课统计
FROM 课程表 JOIN 选课表 ON 课程表.课程编号=选课表.课程编号
GROUP BY 课程名称

❾ SQL语句的一道题 三个基本表：学生表(Student)、课程表（Course）、学生选课表（SC）

1. select * from SC
2. select Sname，Sage from Student where Sdept = '计算机'
3. select Sno,Cno,Grade from SC where Grade >= 70 and Grade <= 80
4. select Sname,Sage from Student where Sage between 18 and 20 and Ssex = '男'
5. select top 1 Grade from SC where Cno = 'C01'
6. select max(Sage),min(Sage) from Student
7. select Sdept,sum(Sno) from Student group by Sdept
8. select course.Cname,sum(sc.Sno),max(Grade) from SC
join studet on Student.Sno = SC.Sno
join Course on Course.Cno = SC.Cno
group by course.cname,max(grade)

9. select sum(Cno),avg(Grade) from SC
join Course on Course.Cno = SC.Cno
join Student on Student.Sno= SC.Sno
order by SC.Sno

10. select Stuent.Sno，Stuent.Sname，sum(Grade) A from SC
join Student on Student.Sno = SC.Sno
group by sc.Sno,student.Sname
having A > 200

11. select Student.Sname,Student.Sdept from Student
join Course on Course.Cno = SC.Cno
join SC on SC.Sno = Student.Sno
where SC.Cno = 'C02'

12. select Student.sname,course.cno,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno
where sc.grade >= 80
order by sc.grade desc

13. select cno,cname from
(
select course.cno,course.cname,sun(sno) from student
join course on course.cno = sc.cno
join sc on sc.sno = student.sno
group by cno,cname
having sun(sno) > 0
)

14. ① select student.sname,student.sdept from
(
select student.sname,student.sdept,course.cname from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where course.cname = 'C01'
)

② select student.sno,student.sname from
(
select student.sno,student.sname,student.sdept,sc.grade from sc
join student on student.sno = sc,sno
where student.sdept = '信息' and sc.grade >= 80
)

③ select top 1 student.sname from
(
select student.sname,student.sdept,sum(sc.grade) from sc
join student on student.sno = sc.sno
where student.sdept = '计算机'
group by student.sname,student.sdept
order by
)

15. delete from sc where grade < 50
16. update sc set grade += 5 from sc
join course on course.cno = sc.cn
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from sc
join course on course.cno = sc.cno
where course.cname = 'c01'
)

17. update sc set grade += 10 from sc
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where student.sdept = '计算机' and course.cname = '计算机文化基础'
)

18. create view [A] as
select student.sno,student.sname,student.sdept,course.cno,course.cname,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno

19. create view [A] as
select student.sno,avg(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

20. create view [A] as
select student.sno,sum(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

21. create index A on student(sname)
22. 不会

❿ 用SQL语言创建三张表 ， 学生表S，学生修课表SC，课程表C

哎 孩子这个还真像帮你做
不过你这分数和题量不大合适
其实还是懒了呵呵
不过你打了这么多字 要是不是复制的话 好好看书其实做更快了
SQL语句还是挺简单的 都不难 期末老师还是会考的