USE lab09;

#Step 1: Create view of the SELECT statement returning all Computer Science students
CREATE VIEW CompSciStudents AS
	SELECT * FROM student WHERE StudentProgram LIKE 'Computer Science';

#Step 2: Displaying the results by navigating through the sidebar uses the following command (copy pasted from new SQL window)
SELECT * FROM lab09.compscistudents;