AND condition in SQLite

SQLite AND
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.

Syntax:

SELECT column_1, column_2, column_N   
FROM table_name  
WHERE condition_1 AND condition_2...AND condition_N;   

Example:
TEACHERS Table:

IDNAMEAGESUBJECT
1Jim27English
2John30Geology
3Watson28French
4Holmes40Chemistry
5Tony35Physics
SELECT * FROM TEACHERS
WHERE ID > 2 AND AGE >= 30;

Output:

IDNAMEAGESUBJECT
2John30Geology
4Holmes40Chemistry
5Tony35Physics

Explanation:
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.

Please Share