Raise the price of every poetry book by 10% and RETURN title and the new price.

Answer

UPDATE books SET price = price * 1.10 WHERE genre = 'poetry' RETURNING title, price;