Exercise: Create View
Create view of Python students.
Solution
sql
1CREATE VIEW python_students AS
2SELECT * FROM students WHERE course = 'Python';
Create view of Python students.
1CREATE VIEW python_students AS
2SELECT * FROM students WHERE course = 'Python';