SQL

and operator

Or operator : || 
And operator : &&

and operator

+--------+--------+--------+
| Value1 | Value2 | Result |
+--------+--------+--------+
|    0   |    0   |    0   |
+--------+--------+--------+
|    0   |    1   |    0   |
+--------+--------+--------+
|    1   |    0   |    0   |
+--------+--------+--------+
|    1   |    1   |    1   |
+--------+--------+--------+

AND Operator (AND)

SELECT *
FROM Customers
WHERE last_name = 'Doe' AND country = 'USA';