丅S課程表

① 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. 不會

② 使用t-sql語句創建course表,課程表

create table course
(
courseID int primary key,
courseName varchar(30)
)

③ Student(S#,Sname,Sage,Ssex) 學生表 Course(C#,Cname,T#) 課程表 SC(S#,C#,score) Teacher(T#,Tname)

除了sex和age都用string類型的吧，不然會麻煩

④ 教師表A(tno,tname),課程表B(tno,cno,cname),列出每個教師的課程數，SQL語句怎麼寫啊

⑤ 數據表 學生表，老師表，課程表，成績表 S（S#,Sname）T(T#,Tname,age)C(C#,Cname,T#) SC(S#,c#,sore)

1. select 學號，avg(成績復) from 表名 where avg（成績）>60 group by 學號
2、制update 表名 set 名字=』王文『 where 課程=『地理』
3和4 我不寫了 我不清楚欄位是什麼 。這個都應該是操作多張表 你根據他們的關聯性去寫吧 關聯性 有找主外鍵用主外鍵作為條件，沒有就找關聯性 相同的欄位，進行修改、刪除操作

⑥ 問問經常做T25的小伙們，周五的課程表有兩項，是都要做，還是選一項做

當然是都做，後面兩個階段也是都有這樣一天兩節的。

⑦ 課程表中的G.S.,I.T.,M.I.是什麼課

外貿口越家外匯相應百姓家庭首快速增加口東西要外購買花錢買產品相應沒更錢投資必須擴內需才能帶投資熱潮（拉經濟增三杠桿——口貿易股市期貨擴內需）

⑧ 有四張表 student(s#,sname,sage,sex)學生表，Course(c#,cname,t#)課程表，SC（s#,c#,score）成績表，

全部通過測試-----
第一題
select a.sno,count(a.sno) as 選課數,Sum(c.score) as 總成績
from student as a,course as b,SC as c
where a.sno=c.sno and b.cno=c.cno
group by a.sno
第二題
select sno,sname from student
where sno in(
select distinct(d.sno)
from student as d,sc as e
where
d.sno=e.sno and e.sno<>'001' and
e.cno in
(
select b.cno
from student as a,course as b,SC as c
where a.sno=c.sno and b.cno=c.cno and a.sno='001'
))
第三題
update sc
set score=(select e.cavgScore from(
select cno as classno,avg(score) as cavgScore
from sc
where cno in(
select cno
from course as a,teacher as b
where tname='葉平')
group by cno) as e where classno=cno)
第四題
delete from sc
where sc.cno in
(
select a.cno
from course as a,teacher as b
where a.tno=b.tno and b.tname='葉平'
)

⑨ 外國大學的課程表上的這些名詞是什麼意思 LET ONLY, S/U ONLY；還有TR,MW,M,,F,T等

我也在找答案，不過我知道的比你稍微多一點，LET ONLY意思是只有講座，TR可能是周四M是周一W周三F周五T周二，但是我們學校選課表上出現了單獨的R我弄不清楚了，不過先幫了你吧