A view is created with the CREATE VIEW statement.

CREATE VIEW view_name AS
SELECT column1, column2,
FROM table_name
WHERE condition;