S10 Select AND OR NOT

AND

SELECT * FROM regtable
WHERE Country=’India’ AND City=’Delhi’;

OR

SELECT * FROM regtable
WHERE City=’Delhi’ OR City=’Mumbai’;

NOT

SELECT * FROM regtable
WHERE NOT Country=’Delhi’;

Combining

SELECT * FROM regtable
WHERE Country=’India’ AND (City=’Delhi’ OR City=’Mumbai’);

SELECT * FROM regtable
WHERE NOT Country=’India’ AND NOT Country=’Poland’;