用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語句還是挺簡單的 都不難 期末老師還是會考的