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

-16t2+64t+80 graph points
if 3 3/4 pounds of candy cost $20.25, how much is 1 pound of candy
List three things you should consider when selecting a career.
At a gymnastics competition, Joey scored 9.4, 9.7, 9.9, and 9.8. Carlos scored 9.5, 9.2, 9.7, and 9.6. Who had the greater average score? By how many point wa
On tuesday, donovan earned $11 for $2 of babysitting. on saturday, he babysat for the same family and earned $38.50. how many hours did he babysit on saturday?
You are cutting as many 32 1/4 inch sections as you can out of the board to make skateboards. how many skateboards can you make?
What is the ansewr to 4 times 5 times 12 plus 3 minus 2 minus 7?
In what nations land claims did the Rocky Mountains mainly fall?
A search plane covers 50 square miles of countryside.How many hectares does the plane search(to the nearest tenth)?
e. coli can be considered a manufacturing unit in the field of genetic engineering.explain this statement.
good job