MySQL Update Table Statement Exercises: Change the email column of employees table with 'not available' for employees of department_id is 80 and commission less than .20 percent

MySQL Update Table Statement: Exercise-4 with Solution

Write a SQL statement to change the email column of employees table with 'not available' for those employees whose department_id is 80 and gets a commission is less than .20%.

Here is the sample table employees.

UPDATE employees 
SET email='not available'
WHERE department_id=80 AND commission_pct<.20;

Let execute the above code in MySQL 5.6 command prompt

See the result. Only the effected rows have been displayed.

+-------------+------------+-----------+---------------+--------------------+------------+--------+---------+----------------+------------+---------------+
| EMPLOYEE_ID | FIRST_NAME | LAST_NAME | EMAIL         | PHONE_NUMBER       | HIRE_DATE  | JOB_ID | SALARY  | COMMISSION_PCT | MANAGER_ID | DEPARTMENT_ID |
+-------------+------------+-----------+---------------+--------------------+------------+--------+---------+----------------+------------+---------------+
|         155 | Oliver     | Tuvault   | not available | 011.44.1344.486508 | 1987-08-11 | SA_REP | 7000.00 |           0.15 |        145 |            80 |
|         163 | Danielle   | Greene    | not available | 011.44.1346.229268 | 1987-08-19 | SA_REP | 9500.00 |           0.15 |        147 |            80 |
|         164 | Mattea     | Marvins   | not available | 011.44.1346.329268 | 1987-08-20 | SA_REP | 7200.00 |           0.10 |        147 |            80 |
|         165 | David      | Lee       | not available | 011.44.1346.529268 | 1987-08-21 | SA_REP | 6800.00 |           0.10 |        147 |            80 |
|         166 | Sundar     | Ande      | not available | 011.44.1346.629268 | 1987-08-22 | SA_REP | 6400.00 |           0.10 |        147 |            80 |
|         167 | Amit       | Banda     | not available | 011.44.1346.729268 | 1987-08-23 | SA_REP | 6200.00 |           0.10 |        147 |            80 |
|         171 | William    | Smith     | not available | 011.44.1343.629268 | 1987-08-27 | SA_REP | 7400.00 |           0.15 |        148 |            80 |
|         172 | Elizabeth  | Bates     | not available | 011.44.1343.529268 | 1987-08-28 | SA_REP | 7300.00 |           0.15 |        148 |            80 |
|         173 | Sundita    | Kumar     | not available | 011.44.1343.329268 | 1987-08-29 | SA_REP | 6100.00 |           0.10 |        148 |            80 |
|         179 | Charles    | Johnson   | not available | 011.44.1644.429262 | 1987-09-04 | SA_REP | 6200.00 |           0.10 |        149 |            80 |
+-------------+------------+-----------+---------------+--------------------+------------+--------+---------+----------------+------------+---------------+

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement to change the email and commission_pct column of employees table with 'not available' and 0.10 for those employees whose department_id is 110.
Next: Write a SQL statement to change the email column of employees table with 'not available' for those employees who belongs to the 'Accounting' department.