Chapter 5, Problem 11SCG

Program Plan Intro

AND Operator:

In SQL, “AND” keyword is used in order to check two and more than two conditions. This usually works well with “WHERE” clause.

Syntax:

SELECT * FROM table_Name WHERE condition1 AND condition2;

“NOT IN” Operator: In SQL, “NOT IN” operator is used to select values from the table which are not equal to any of the values from the mentioned table.

Syntax:

SELECT column_Name(s) FROM table_Name WHERE column_Name NOT IN (value1, value2, ...);