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

10 POINTS! science plz help me!
A major until of the genetic code is called an
A 2-kg bowling ball sits on top of a building that is 40 meters tall. Circle one: KE / GPE / both Show your work for finding the values of each type of energy t
Estimate the circumference of the circle with the given radius or diameter. Use 3.14 for ?. Round to the nearest unit. (Half. 24in written inside the circle) 1.
What is one characteristic of a sample of matter that indicates it is a pure substance?A)It can be separated using by a physical means, such as filtering.B)The
Which fossils would you expect to find in a rock that is 405 million years old?
What is 9 less than the quotient of two and a number x​
Please I need help with this quick!!
A Healthy school lunch is $.75 more than the current lunch has a higher economic
What are the features of the Outline view in Word? Select three options. a.making it easier to deal with larger documents b.manipulating headings c.displaying t