AND, OR, and NOT operators are combined with the WHERE clause to get the desired filtered results.
e.g SELECT * FROM Users
WHERE State =’illinois’ AND City=’Chicago’;
e.g SELECT * FROM Users
WHERE City=’Chicago’ OR City=’New York’;
e.g SELECT * FROM Users
WHERE NOT State =’Chicago’;