写一个课程表

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

② 用C#winform写一个类似课程表，怎样写。

datagridview可以做啊
数据库的表结构先设计好，在datagridview里写你的课程，然后保存到数据库，就行啦，很简单的

③ 以课程表为题写一篇作文

一个暴日炎炎的下午，我们正在上语文课。哎！说起来就伤脑筋，这已经是今天上的第N节语文课了，有些课的老师不是参加什么活动，就是请了病假。

我无精打采地坐在座位上，仰起头，看着教室里白花花的墙壁，发起呆来。

我心里想：如果让我来安排课表那该多好哇！如果真有怎么一天，我会与众不同的安排课表。

首先，是令人苦恼的星期一。以前每到这个时候，我总是想：这得什么时候才能熬到“解放”啊！我将把这一天所有的课程踢开，整天都是电脑课，让孩子们放松一下心情。接着是星期二，这一天要全是体育课，把扫兴的老师和下课铃声通通不要，让孩子们一玩起来就没有尽头！星期三是独一无二的“零食课”，让孩子们吃个够。星期四来临了，该安排什么好呢？睡觉课？不行，不行。哎有了！来个凤凰山游乐场一日游，我将亲自带领孩子们在凤凰山森林公园玩个痛快。星期五一眨眼就到了，开始进入正课时间，先上一节为时15分钟的语文课，作业的，不留！再来一节同样时间的数学课，仅仅布置一道计算题做做！上完了就马上放学。另外，我还要安排一个月一次的有趣的出游活动，一个学期还要有两次运动会……

如果让我安排课表的话，我会每一周更新一次课表，让人感觉无比新奇。

④ SQL查询，学生表，课程表，成绩表的一个查询要求如下怎么写呢

selects.sid,s.sname,sc.scorefromstudent,course,scwherestudent.sid=sc.sidandcourse.cid=sc.cidandcourse.cname='影视设计';

注意一下，你自己写的sid和sname中间没有逗号，到时候一定执行报错

⑤ 英语作文:由一张课程表写一篇英语作文

today
is
周一/周二/周三来/周四··源····（日期自己写，我也不知道这是你哪天的课程），i
have
two
classes
in
the
morning
.we
start
the
lessons
at
8:30.
the
first
class
is
english,and
the
second
class
is
maths.then
we
take
a
rest
at
midday.
in
the
afternoon,we
have
four
classes.the
first
one
is
biology
.
the
second
one
is
politics
.
the
third
one
is
the
sports
lesson,
and
the
last
one
is
maths.the
school
will
be
over
at
about
5:30.
after
school,we
go
home
happily.
in
these
classes,
political
is
my
favourite
lesson,becaus
the
teacher
is
very
interesting.
如果哪儿不合适最好自己改改，我也是现写的，希望能帮上你的忙。

⑥ 我写了一个学生表（学生id，学生名字），写了一个课程表（课程id，课程名字，学生id）

外键关联的是另一张表的主键，将本表的这个字段的值约束在关联的主键范围内。

你这个需求可以写触发器实现的

⑦ 仿写课程表在写一个

额，只要换下顺序就可以了吧

⑧ c语言怎样编写课程表，请问程序怎样写

链表存，
没学链表就数组+结构体完成。还没学结构体的话你就再啃啃C语言吧

⑨ 课程表怎么写啊啊啊啊

你是要英语版的还是中文版的，建议用电脑了的excel设置 然后根据你自己的课程设置啊！不然去网上下载一个超级课程表

⑩ php 写一个课程表

course表: course_id,course_name
course_schele表： sc_id, week_id, lession_id, course_id