To create view in sql

Question

Create view vtest as select from mytable

Answer 1

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

learn more https://www.tutorialspoint.com/sql/sql-create-view.htm