Create View Syntax:

CREATE VIEW my_view_name AS
SELECT column_name(s)
FROM my_table_name
WHERE condition

Create View Example:

Sales table:

CREATE VIEW sales_view AS
SELECT id, price, name
FROM sales
WHERE price=500;

Create View Result: