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

When Grendel speaks of unferth sand says "I could crush him like a fly" what literary device is being used
edgar is being asked to try tobacco he uses a quit voice when he says i don't think so this is an example of nonverbal communication
Two sides of a triangle have lengths 5 and 12. What must be true about the length of the third side?
Complete the equation for photosynthesis. + water + oxygen In light-dependent reactions, energy is absorbed and converted into energy in the form of .
The table below shows the land-speed records to the nearest mile per hour. Draw a scatter plot for the data and use it to predict the approximate land-speed rec
ANSWER FAST PLEASE!!!
name the two lymphoid organs in the chest and abdomen
What is the written formula for speed?
Which is the graph of the function f(x) =1/2 x2 + 2x – 6?
Sue is always cramming to hand in an assignment of take assignment or take an exam .What time management advices would help sue?