We have a table books below. Write an SQL statement to:
-
set price as NULL
-
add 'Sold Out - ' in the beginning of the name
-
update publisherName to HYDRA Corp.
for all the books whose publisherName is HYDRA Inc.
Note: If you want to add 'Prefix - ' to values in a column x, add x = 'Prefix - ' || x in the SET list.