create view course_result as select stuNo 学号, stuName 姓名, courseNo 课程号, courseName 课程名, courseResult 成绩from tableName
