breashaeeboo3094 breashaeeboo3094
  • 06-11-2020
  • Computers and Technology
contestada

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%.

Respuesta :

IfeanyiEze8899 IfeanyiEze8899
  • 10-11-2020

Answer:

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.

Answer Link

Otras preguntas

What was the major provision of the Treaty of Paris of 1763 that ended the French and Indian War?
Calculate the average speed of Charlie who runs to the store 4 km away in 30 minutes
what is x in -8(x-1)
PLEASE HELP ASAP!!! CORRECT ANSWERS ONLY PLEASE!!! What are the domain and range of the function?
Proteins differ from carbohydrates in that most proteins contain ?
How to find slope of a line
PLEASE HELP ASAP!Gideon never wanted to visitA. the veldB. the son C. his kraalD. mr. farquar
Solve the inequality 0 > –3x – 2x.
In humans, chemical digestion is accomplished by enzyme action that begins in the mouth and ends in t
What is the area of the figure? A) 305 cm2 B) 315 cm2 C) 390 cm2 D) 400 cm2