Chapter 5, Problem 4SCG

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;

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

Syntax:

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