To make multiple comparisons with different operators in the same statement, the SQLite AND Operator are used. It is generally used with SELECT, UPDATE and DELETE statements. It is a conjunctive operator and is always used with the WHERE Clause.
SELECT column_1, column_2, column_N FROM table_name WHERE condition_1 AND condition_2...AND condition_N;
SELECT * FROM TEACHERS WHERE ID > 2 AND AGE >= 30;
The “TEACHERS” is an already existing table. Here we are selecting those rows of the table where the value in the ID column is greater than 2 and the value in the AGE column is greater than or equal to 30.