Write an UPDATE statement on the customers table to SET the years_old column to 42 for any customer with a last_name of Hall.

Select the correct answerConsider a database table called "Employees" with the following columns:  EmployeeID (integer)  Name (text)  Age (integer)  Department (text)Sample data:What is the SQL query to update the age of the employee with EmployeeID 3 to 29?OptionsUPDATE Employees SET Age = 29 WHERE EmployeeID = 3;UPDATE Employees SET Age = 29 WHERE Name = 'Mike Davis';UPDATE Employees SET Age = 29 WHERE Age = 28;UPDATE Employees SET Age = 29;

You have a table named pamperedPets. The table tracks the pets of customers by pet_id. There is a record for a pet whose pet_id is 10. You need to change the value of the age field from 7 to 8. You open MySQL Workbench and begin typing your query:UPDATE pamperedPets SET age = 8WHERE pet_id = 10;You execute the statement. You then execute a SELECT statement and discover that the record has not been updated. What must you do to update the table?1 pointChange the query to UPDATE pamperedPets WHERE pet_id=10 SET age=8Change the query to UPDATE pamperedPets SET age=8 WHERE pet_id IN (SELECT pet_id FROM pamperedPets WHERE pet_id=10)Change the query to UPDATE pamperedPets SET age=8You should execute the SET SQL_SAFE_UPDATES=0 statement.

Consider a database table called "Employees" with the following columns:  EmployeeID (integer)  Name (text)  Age (integer)  Department (text)Sample data:What is the SQL query to update the age of the employee with EmployeeID 3 to 29?OptionsUPDATE Employees SET Age = 29 WHERE EmployeeID = 3;UPDATE Employees SET Age = 29;UPDATE Employees SET Age = 29 WHERE Name = 'Mike Davis';UPDATE Employees SET Age = 29 WHERE Age = 28;

select customerid,concat_ws(" ",firstname,lastname) as name,timestampdiff(curdate(),Date_of_Birth,Year) as agefrom customersorder by age,customeridcorrect this

The employee table contains information about employees. One of your employees got married, so herlast name changed. What command should you use to reflect this change in the table?