Create Table As Select

The following command will create a table called luxury_apartments by querying the apartments table, and keeping the rows where suggested_price > 2000

PostgreSQL, MySQL, Oracle

SQL Server

CREATE TABLE
    luxury_apartments
AS
    SELECT
        * 
    FROM
        apartments
    WHERE
        suggested_price > 2000;