几个代码的问题，请教各位！
Tables：
exam (excode, extitle, exlocation, exdate, extime)
student (sno, sname, semail)
entry (eno, excode, sno, egrade)
cancel (eno, excode, sno, cdate, cuser)
questions：
P. Produce a table showing the examination timetable for a given student. The student is specified by his/her student membership number. The timetable should contain the student's name and the location, code, title, day and time of each examination for which the student has entered.
给定一个学号sno=100, 创建 为这个学生的timetable，要求这个table里name, location, code, title, day, time.
Q. Produce a table showing the result obtained by each student for each examination. The table should be sorted by examination code and then by student name. If the student is awarded a grade of 70% or more then the result is to be shown as 'Distinction', a grade of at least 50% but less than 70% is to be shown as 'Pass' and grades below 50% are to be shown as 'Fail'. If the student has not taken the examination then the result is shown as 'Not taken'.
创建一个table（code, name, result），保存每个学生的每门成绩，要求先按excode排序，再按sname排。如果这个学生的成绩>70% result里显示Distinction, >50% && <70% 显示 PASS, <50% 显示 Fail。
问题点数：0、回复次数：1Top
1 楼homeland520（天山之王（哈哈两声说Beybey)）回复于 2004-12-12 17:33:53 得分 0
upTop
