Online,

CodePudding user response:

USE teaching2.
The CREATE OR REPLACE the VIEW ` student_course_sc ` AS
SELECT
Student. Sno, student, sname, student course, student. Cno, student. Score
The FROM
Student, sc
Where
Student. Sno=sc. Sno;