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.