Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Basic UPDATE statement

Update Age with SQL Magic

Report a typo

Given a database table 'Customers' with columns 'birth_date', 'current_date' and 'age'. Which of the following SQL UPDATE statements correctly apply the arithmetic expression to calculate and update the 'age' column (based on the 'birth_date' and 'current_date' columns), where 'age' is NULL or less than 18?

Select one option from the list

UPDATE (current_date - birth_date) / 365 SET Customers WHERE age IS NULL OR age < 18;

UPDATE Customers WHERE age IS NULL OR age < 18 SET age = (current_date - birth_date) / 365;

UPDATE Customers SET age = (current_date - birth_date) / 365 WHERE age IS NULL OR age < 18;

UPDATE Customers SET age WHERE (current_date - birth_date) / 365 IS NULL OR age < 18;

UPDATE Customers SET ((current_date - birth_date) / 365) = age WHERE age IS NULL OR age < 18;

___

Create a free account to access the full topic