SQL AND

The AND command is similar the WHERE command, but you use WHERE for the first filter statement, and you use AND for all subsequent filter statements.

-- Works in PostgreSQL, MySQL, SQL Server, and Oracle SELECT * FROM rent_payments WHERE dollar_amount > 1800 and building_id = 1;

rent_payments table

building_id payment_date dollar_amount
1 3/1/2018 2000
1 3/2/2018 1500
2 3/1/2018 1800
2 3/3/2018 1900
1 4/2/2018 2000
1 4/2/2018 1500
2 4/1/2018 1800
2 4/2/2018 1900

Query results

building_id payment_date dollar_amount
1 3/1/2018 2000
1 4/2/2018 2000