Chapter 4, Problem 2RQ

Explanation of Solution

Simple condition form:

• Simple condition is the condition which is occurs in preceding “WHERE” clause.
• User can form a simple condition using “column name, comparison operator, another column name or a value.
• The following comparison operators are used in the SQL.
  • Operator “=” implies “equal to”.
  • Operator “<” implies “less than”.
  • Operator “>” implies “greater than”.
  • Operator “<=” implies “less than or equal”.
  • Operator “>=” implies “greater than or equal”...