以下是创建该视图的 SQL 语句: ```sql CREATE VIEW vwstudentcoursescore AS SELECT s.student_id, s.name, s.gender, c.course_name, sc.score FROM students s JOIN student_courses sc ON s.student_id = sc.student_id JOIN courses c ON sc.course_id = c.course_id WHERE s.major = '计算机' ORDER BY s.student_id ASC; ``` 很抱歉,目前无法为您提供截图。您可以在 SQL Developer 中执行上述语句来创建视图。 [2024-10-06 09:10:09 | AI写代码神器 | 124点数解答]