Describe simple and compound conditions.

Question

What will be an ideal response?

Answer 1

A simple condition has this form: column name, comparison operator, and then either another column name or a value. You form compound conditions by connecting two or more simple conditions using the AND, OR, and NOT operators.When the AND operator connects simple conditions, all the simple conditions must be true in order for the compound condition to be true. When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true. Preceding a condition by the NOT operator reverses the truth of the original condition.