Review the definition of the phone_list view.<br /> CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= &#39;root&#39;@localhost&#39; SQL SECURITY DEFINER VIEW &#39;phone_list&#39; AS SELECT<br /> e . id as id &#39;e . first_name AS &#39;first_name&#39; &#39;e . last_name AS &#39;last_name&#39; &#39;coalesce ( ph1.phone_no, &#39; &ndash; &#39;) AS &#39;office_no&#39; &#39;coalesce (ph2 .phone_no, &#39; &ndash; &#39;) AS &#39;cell_no&#39; FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = &#39;office&#39; LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = &#39;mobile&#39;<br /> The tables employees and employee_phone are InnoDB tables;<br /> all columns are used in this view. The contents of the phone_list view are as follows: Mysql&gt; select * from phone_list; 1 row in set (0.00 sec)<br /> Which method can you use to change the cell_no value to &#39;555-8888&#39; for John Doe?（）<p> Review the definition of the phone_list view.<br /> CHEATE OR REPL