SQL CREATE VIEW
The following command will create a view called luxury_apartments. This view will contain all rows in the apartments table where suggested_price > 2000
-- Works in PostgreSQL, MySQL, SQL Server, and Oracle.
CREATE VIEW
luxury_apartments
AS
SELECT
*
FROM
apartments
WHERE
price > 2000;