DROP VIEW StudentProf;

@createTable;

CREATE VIEW studentProf(student, professor) AS
SELECT sNumber, pName
FROM Student, Professor
WHERE professor=pNumber;
