Chegg Due to inflation, the cost of all books published in 2016 will increase by 5%. Write a single SQL command to increase all book costs by 5%.

UPDATE books

   SET cost = cost + (cost * 0.5)

   WHERE publish_year = 2016;

Explanation:

The UPDATE clause of SQL or structure query language is used to change the value of an existing queried row or group of row values.

The books is the table name, cost is the row value to be changed and publish_year is the condition to subset or query target rows.

hi, you. i think this we be deleted because it's a invalid question.

(i suggest no to do this in the