Writing Conditions with WHERE
1.1 The conditional expression SQL determines on which lines will be performed an operation by means of a conditional expression in the WHERE clause. At each line of the table, the expression conditional is re-evaluated based on line-specific values. If the expression evaluates to TRUE, then the requested operation (SELECT,…