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;